Sql excution plan in oracle - 12c

As salamo alaikum wa rahmatullah

c:\windows\system32>sqlplus scott/tiger
sql>explain plan for select ename,dname from emp natural join dept;
select * from table(dbms_xplan.display);
sql>set autotrace on
sql> explain plan for select ename,dname from emp natural join dept;
sql> select * from table(dbms_xplan.display);
sql>select * from table(dbms_xplan.display_cursor(format=>'allstats last'))


Thanking you
--
Mohammad Shahnawaz
Passion for Oracle