SQL> explain plan for select * from emp where rownum<=10
2 ;
Explained.
SQL> select * from table(dbms_xplan.display);
0 SELECT STATEMENT
1 COUNT STOPKEY
2 TABLE ACCESS FULL
1-filter(ROWNUM<=10)
SQL> explain plan for select * from emp where rownum<=10
2 ;
Explained.
SQL> select * from table(dbms_xplan.display);
0 SELECT STATEMENT
1 COUNT STOPKEY
2 TABLE ACCESS FULL
1-filter(ROWNUM<=10)