select table_name from all_tables where owner ='SYSTEM'
晕... 这样的问题每天会见到N多,建议本版尽快充实精华区的内容. 1. 创建序列和触发器 CREATE sequence seq_for_ID minvalue 1 start with 1 increment by 1 nocache;CREATE or replace trigger trig_for_insert before insert on 表名 for each row
BEGIN select seq_for_ID.nextval into :new.列名 from dual; END; / 2. select table_name from all_tables where owner='用户名'
对,使用序列就可以 create or replace sequence seqname start with 1 increment by 1 maxvalue 99999使用的时候只要用: seqname.nextval 就可以了
select table_name from all_tables where owner ='SYSTEM'
晕... 这样的问题每天会见到N多,建议本版尽快充实精华区的内容. 1. 创建序列和触发器 CREATE sequence seq_for_ID
minvalue 1
start with 1
increment by 1
nocache;CREATE or replace trigger trig_for_insert
before insert on 表名
for each row
BEGIN
select seq_for_ID.nextval into :new.列名 from dual;
END;
/ 2. select table_name from all_tables where owner='用户名'
create or replace sequence seqname
start with 1
increment by 1
maxvalue 99999使用的时候只要用:
seqname.nextval
就可以了