explain plan on Oracle SQL Live 18c

select sysdate from dual;
select * from table( dbms_xplan.display_cursor);
explain plan for
select sysdate from dual;
select * from table( dbms_xplan.display);


Oracle Live SQL

    SQL Worksheet



Result Set 11

SYSDATE
17-FEB-18

Download CSV
Result Set 12

PLAN_TABLE_OUTPUT
User has no SELECT privilege on V$SESSION

Download CSV
Statement processed.
Result Set 13

PLAN_TABLE_OUTPUT
Plan hash value: 1388734953

-----------------------------------------------------------------
| Id  | Operation        | Name | Rows  | Cost (%CPU)| Time     |
-----------------------------------------------------------------
|   0 | SELECT STATEMENT |      |     1 |     2   (0)| 00:00:01 |
|   1 |  FAST DUAL       |      |     1 |     2   (0)| 00:00:01 |
-----------------------------------------------------------------

Download CSV
8 rows selected.
Live SQL 18.1.2, running Oracle Database 18c Enterprise Edition - 18.1.0.0.0 Set Screen Reader Mode On
© 2018 Oracle Corporation · Privacy · Terms of Use
Live SQL Home · About · Oracle Database on OTN · Oracle Learning Library · Oracle Database Documentation 18c , 12c · Follow on Twitter
Oracle Live SQL - SQL Worksheet