Search notes:

Oracle SQL Plan operation SEQUENCE

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      |          |
-- -------------------------------------

See also

sequence
Plan operations

Index