Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I have downloaded the latest version of SQLDeveloper, which is 18.1.0.095.1630. I am not able to query any view from sqldeveloper.
select count(*) from MY_VIEW_V;
no rows selected
From sqlplus :
Can you query user_objects or v$sessions - those are views.
Check your NLS parameters and inspect any login or glogin scripts available to sqlplus...make sure these are set appropriately for SQLDev as well.