I am writing few queries on Toad, and there are actually few peoplesoft tables.
I am trying to insert some data into these tables. These are the tables through which the PeopleSoft Interface screens get populated. I am not getting any kinds of errors while inserting the data and when I test the interfaces with newly inserted data. data looks good.
But I am facing a weird issue.
When I am running a simple query say : (shown in figure)
select * from ps_course_tbl
where tims_course_owner = 'DARTX';
It fetched me with the correct data and when I trying to do a describe on it, the columns look weird .....all the columns have some kind of garbage.
And seconldly when I select the data tab in the new window which opens. It shows me an invalid identifier error.
Did anyone face this issue.
Please look at my 2nd figure.
Any kind of help is greatly appreciated.