DECLARE V_SEQ NUMBER(16); BEGIN EXECUTE IMMEDIATE 'SELECT NVL(MAX(col1),0)+1 FROM tab1' INTO V_SEQ; EXECUTE IMMEDIATE 'CREATE SEQUENCE tab1_col1_SEQ START WITH '|| V_SEQ || ' CACHE 20'; END; / |
DBA's Home Page - A website for Oracle, Greenplum and PostgreSQL DBA's > DBA's Forum, Routine Tasks and Activities >