ROWID + CONNECT BY + SUBQUERY = ERROR

View All Public Scripts Login to Run Script

Statement 1

This works fine

Basic ROWID

SELECT rowid, d.* FROM DUAL d


ROWID DUMMY
AAAACPAABAAAAShAAA X

ROWID	DUMMY
AAAACPAABAAAAShAAA	X

Statement 2

Works fine as well

ROWID in Subselect

SELECT * FROM(SELECT rowid, d.* FROM DUAL d)


ROWID DUMMY
AAAACPAABAAAAShAAA X

ROWID	DUMMY
AAAACPAABAAAAShAAA	X

Statement 3

Also works

ROWID with CONNECT BY LEVEL

SELECT rowid, LEVEL FROM DUAL CONNECT BY LEVEL < 2


ROWID LEVEL
AAAACPAABAAAAShAAA 1

ROWID	LEVEL
AAAACPAABAAAAShAAA	1

Statement 4

This is where it breaks

ROWID + CONNECT BY + Subquery

SELECT * FROM( 
    SELECT rowid, LEVEL FROM DUAL CONNECT BY LEVEL < 2)

ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.

Additional Information