View data not available
Hi All, I ha d installed SQL developer software , I tried running queries using select statements I am not getting any records when I run select * from eam_pm_schedulings_v; but when I run select * from eam_pm_schedulings , I am getting SQL query output. In short when i run select statement on view , no data is retrieved. Am I missing any setup or problem with developer Regards,Sanjeev
Hi Sanjeev, when you open the view in the Object Viewer from the Connections window, can you see any data in the Data tab?Can you see the DDL for generating the view in the SQL tab ob the Object Viewer? What happens if you execute just the select part from the DDL? Regards,Sabine
Hi Sabine, Data is not visible , but DDL is generated please refer the screen shot attached Regards,Sanjeev
What happens if you execute just the select part from the DDL? Does your user have all the select grants for all referenced tables? You are using at least three different objects, aren't you?
I ha d installed SQL developer software , I tried running queries using select statements I am not getting any records when I run select * from eam_pm_schedulings_v; but when I run select * from eam_pm_schedulings , I am getting SQL query output. Ok - but that just suggests that the query for the view is NOT just a select from that one table. So since those are two DIFFERENT queries you can't really compare the output This is NOT really a sql developer question so should be posted in the SQL and PL/SQL forum.SQL and PL/SQL When you repost you need to provide ALL of the info needed to help you and that would include the DDL for the view. That DDL should be posted DIRECTLY in the forum so people can see it.
Hi, Please provide the query for view creation and sample data of the tables which are used in view creation.
Hi Sanjeev, Please check the tables involved in the given view (eam_pm_schedulings_v) and confirm the joins used in the view with tables and the data between those tables.And also check the table eam_pm_schedulings whether it is used in the view or not and if used what other tables joined and what setups or data missing. Regards,Bharat
BUG: sqldeveloper 1.5.3 during compiling any procedure
how to view tables in another schema in the database
SQL Developer and 3rd Party Drivers: JavaDB
Cannot create connection with SQL Developer
BUG: Manage database option
probelm with the sql editor window
Comments in quotes '--'
"No JNDI context" error
SQL Developer & MySQL ??
"Use Tabulator" in preferences doesnt seem to work
Open file in current session
Increasing Of Reported Issues' Number
SQL Developer for Oracle install on Vista32
Dropping Java Classes
Publish to Apex