SQL Performance (MOSC)

MOSC Banner

Query returns no rows in 12c

edited Mar 24, 2016 5:05AM in SQL Performance (MOSC) 6 commentsAnswered

Why I'm getting no rows selected below?

SQL> select a.con_id,b.con_id  from cdb_data_files a, v$containers b where a.con_id=b.con_id ;

no rows selected

SQL>  select con_id from cdb_data_files;

    CON_ID

----------

         1

         1

         1

         1

         1

         1

         1

         2

         2

         3

         3

         3

         3

13 rows selected.

SQL>  select con_id from v$containers;

    CON_ID

----------

         1

         2

         3

SQL>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center