- SELECT
- '---'||au.table_name||
- '\\n create or replace
- TRIGGER TRG_'|| au.table_name||'\\n BEFORE INSERT ON '
- ||au.table_name||
- '\\n FOR EACH ROW
- BEGIN
- SELECT SEQ_'||au.table_name||'.NEXTVAL INTO :NEW.'||cu.column_name ||' FROM DUAL;'
- ||
- '\\n END;'
- FROM user_cons_columns cu,
- user_constraints au
- WHERE cu.constraint_name = au.constraint_name
- AND au.constraint_type = 'P'
- AND au.table_name IN
- (SELECT TABLE_NAME FROM USER_TABLES);
- --该片段来自于http://www.codesnippet.cn/detail/1501201511544.html
来源: http://www.codesnippet.cn/detail/1501201511544.html