Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to view data in any of the view objects available in schema that I have access to

tanmalhotJan 28 2019 — edited Jan 29 2019

I am trying to access data of a view fnd_flex_values_vl using Sql developer for Mac OS.

If I run a simple select query in Toad on windows machine, it is retrieving data whereas same sql is not fetching any data in Mac OS.

Same query runs on another colleague's sql developer app on windows 10 os.

Is there any environment that needs to be set to allow data to be fetched?

If I use actual sql used to generate view, data is present in both tables - fnd_flex_values_tl and fnd_flex_values.

Please help.

Regards

TM

Comments

Post Details

Added on Jan 28 2019
#query, #select, #sql-developer
3 comments
606 views