Im using this section to store useful tidbits of SQL or PLSQL
Looping through an Array in PLSQL
DECLARE TYPE array_t IS VARRAY(6) OF NUMBER(38,0); ARRAY array_t := array_t(305, 405, 505, 605, 1005, 1105); BEGIN FOR i IN 1..ARRAY.count loop dbms_output.put_line(ARRAY(i)); END loop; END;
Reset a sequence – Oracle
-- Test SELECT MY_SEQUENCE.nextval from dual; -- Decrement by 1 ALTER SEQUENCE MY_SEQUENCE INCREMENT BY -1 MINVALUE 0; -- Decrement as required SELECT MY_SEQUENCE.nextval from dual; -- Reset Sequence ALTER SEQUENCE MY_SEQUENCE INCREMENT BY 1 MINVALUE 0;