OraFAQ Forum: Reports & Discoverer » Oracle reports problem

Home » Developer & Programmer » Reports & Discoverer » Oracle reports problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle reports problem [message #181455]

Mon, 10 July 2006 03:56

roopesh_ariya
Messages: 2
Registered: July 2006
Location: Bangalore

Junior Member

Hi all,
I have a problem with Oracle in my UNIX system.
In Oracle I have a table view say TAGDETAILS with fields like TAGNAME,TAGDESC,TAGTYPE etc. It has about 150 records.
If I EXECUTE an sql statement "SELECT * FROM TAGDETAILS" ,will show only 3 records.
I know the tagnames in the table. So I wrote another query "SELECT * FROM TAGDETAILS WHERE TAGNAME='TAG345'", this shows the corresponding record correctly.
If again I am executing "SELECT * FROM TAGDETAILS" , now it will show 4 records including 'TAG345'.
Select queries with where clause is not working (except for " where tagname='some tagname'" ).

Please help...

Report message to a moderator

Re: Oracle reports problem [message #181463 is a reply to message #181455]

Mon, 10 July 2006 04:17

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Saying that you have a "table view" which has 150 records, WHAT exactly has 150 records? Table or a view? If it is a table, perhaps the view is created in such a way that it is restricting the table record set (so that you get only 3 records of 150)?

Otherwise, I really wouldn't know what could cause such behaviour ... especially when "SELECT * FROM tagdetails" once returns 3, and another time 4 records (unless someone is modifying the view during your session).

Report message to a moderator