SQL Developer


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

Related Links

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
datamodeler: case

Categories

ORACLE DEV
Replication
Text
Oracle Applications
Designer Headstart
Database Upgrade
Performance & Availabi...
Database Mobile Server...
Oracle Provider for OL...
Oracle Application Exp...
Certification Community
Calendar
Content Services
Calendar Web Services ...
SOA & Process Management
Consumer Sector Collab...
Migration
Workspaces
Oracle Database Expres...
Master Data Management...
Contact Center and Ser...
Performance Management...
Product Hub
SCM - Asset Lifecycle ...
MDM Integration and Bu...
Identity Management Ar...
Upgrades
Test Management/Functi...
Tuxedo Systems and App...
iStore
weblogic.developer.int...
weblogic.support.install
Composite Applications
I(18)N & Localization
Business Services (BPM)
WebLogic Server - Mana...
Retail Data Model
WebLogic Server - WebA...
User Productivity Kit ...
HotSpot Internals [ARC...
Java Technologies for ...
Kerberos & Java GSS (J...
Solaris 11
Bug Examples
Java ME Embedded
Systems Maintenance
Java System Web Proxy ...
AutoVue Enterprise Vis...
初心者の部屋
Java (Japanese)
Database Migration Ass...
Enterprise Gateway
DTrace for Oracle Linu...
Oracle SOA Suite (Japa...
システム管理
Siebel (Chinese)
Talent Management
JD Edwards EnterpriseO...
Java Mission Control
Module Extension (Korean)
Java Enterprise Edition
My Oracle Support Comm...
VirtualBox
Architecture - General...
Resell
Oracle Code Online
Oracle Database Backup...
Eloqua Users - Virginia
CX Central
Privacy and Compliance
Eloqua Digital Adverti...
Web Technology Newsletter
API Management
Oracle Integration Clo...
Oracle Eloqua Training...
Eloqua - BlueKai Integ...
APAC Oracle Marketing ...
Swing & AWT
Oracle IoT Cloud Service
Insurance Group
Data Visualization Des...
Oracle Database Cloud ...
Oracle Cloud Machine
Service Supply Chain
Generic Linux
Database Security - Ge...
Sensor-Based Services ...
기존 포럼(2006년 8월까지 게시물 T...
Security
jrockit.developer.inte...
weblogic.eventserver.g...
Communications Service...
Primavera Archived For...
WebLogic开发
Oracle Communications ...
Oracle Enterprise Mana...

Resources

Encrypt Message