create sequence tq84_seq; explain plan for select tq84_seq.nextval from dual; select * from dbms_xplan.display(format=>'basic'); -- -- ------------------------------------- -- | Id | Operation | Name | -- ------------------------------------- -- | 0 | SELECT STATEMENT | | -- | 1 | SEQUENCE | TQ84_SEQ | -- | 2 | FAST DUAL | | -- -------------------------------------