Select Command Returns 'No Rows Selected' Or Few Rows Than the Actual Rows In The Table
Last updated on FEBRUARY 13, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
User A gets 'no rows selected' while querying user B's table, even though user A has the privileges to select user B tables.
GRANT SELECT ON B.TABLE1 TO A;
-Connect as user A
SQL> connect USERA/password
SQL> show user
USER is "USERA"
SQL> SELECT * FROM B.TABLE1;
no rows selected
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms