Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips
Arguments Source

SEQUENCE_CURRVAL

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
SEQ_NAMEVARCHAR2 IN

Returns:

NUMBER(38)

Source

Legend: comment string keyword reserved word operator
     1: function sequence_currval( seq_name varchar2 ) return number as
     2: 	ret number;
     3: begin
     4: 	execute immediate 'select '|| seq_name || '.currval from dual'
     5: 		into ret;
     6: 	return ret;
     7: end;