1、创建序列CREATE SEQUENCE TABLE_ID_SEQ MINVALUE 1 NOMAXVALUE START WITH 1 INCREMENT BY 1 NOCYCLE NOCACHE; 2、创建触发器CREATE OR REPLACE TRIGGER "SCHEMA"."TABLE_TRIGGER" BEFORE INSERT ON "SCHEMA"."TABLE" FOR EACH ROW WHEN(NEW."id" IS NULL) BEGIN SELECT TABLE_ID_SEQ.NEXTVAL INTO:NEW...
             
一、错误SQL> startup;ORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'二、办法1.SQL> create pfile from spfile='E:\software\oracle\install\product\11.2.0\dbhome_1\database\spfileorcl.ora';说明:E:\software\ora...
回到顶部