oracle为表建立序列,oracle为数据库每张表建立序列

oracle为数据库每张表建立序列

[@more@]

create or replace procedure CREATE_SEQ IS

v_str VARCHAR2(500);

cursor ALLTABLES IS

SELECT s.table_name FROM all_tables s

WHERE s.owner='TEST' AND (s.table_name LIKE 'BASE_%' OR s.table_name LIKE 'BD_%' OR s.table_name LIKE 'CS_%' OR s.table_name LIKE 'ES_%' OR s.table_name LIKE 'FM_%');

begin

FOR allTab IN ALLTABLES LOOP

EXECUTE IMMEDIATE 'create sequence SEQ_'||allTab.Table_Name||

' minvalue 1'||

' maxvalue 999999999999999'||

' start with 1000'||

' increment by 1'||

' cache 20';

END LOOP;

end CREATE_SEQ;