This content has been marked as final. Show 9 replies
Try placing the name of the database in front of the view name:
SELECT * FROM databasename.viewname
What java version are you using?
I haven't heard of any bugs that might cause the behavior you mention. In general, if you own a table or have SELECT granted (either on a specific table or ANY TABLE) then you see the rows. Views are a bit more problematic as seen in this thread:
Re: Incorrect results returned by SQL Developer
Also, the thread in the link below suggestions another possibility -- a security policy may be the cause. Your privileges permit you to see the table's existence but not all rows:
Re: Unable to see TABLE data on SQL DEV
SQL Developer Team
Isn't this one of the symptoms of using JDK7?
Actually I recalled one of the known JDK7 symptoms relates to the SQL Array Fetch Size limit in the query results grid
SQL Developer 3.0 and Java SE 7?
but came up empty in terms of a worksheet query returning no rows at all. You may be correct, especially if the original poster uses the original jdk1.7.0 or one of the very early updates. Perhaps the OP will provide more details.
I tried the way you mentioned but it dint work.
I am using JRE version 1.6.0_37-b06.
I took a screenshot of the problem I am facing.
please find the screenshot on this short url http://goo.gl/7b8Qf
The screenshot implies the connection (your R12 Apps) is the same for both SQL Developer installations. If the connection details really are identical for both cases, then you should also verify any startup script processing is the same for both:
Tools > Preferences > Database > Filename for connection startup scriptIf that is also exactly the same in both cases, then a clean install of the newer version (without settings migration) may be advisable.