后台批量创建数据的时候
sqlserver支持
INSERT INTO A表 ("GUID","姓名","当前时间")
VALUES(NewID(),"张三",GETDATE())
这样的语句,即guid和系统当前时间都有一个方法可以直接获得那么在oracle中有对应的实现方法吗?请给个例子!谢谢!
sqlserver支持
INSERT INTO A表 ("GUID","姓名","当前时间")
VALUES(NewID(),"张三",GETDATE())
这样的语句,即guid和系统当前时间都有一个方法可以直接获得那么在oracle中有对应的实现方法吗?请给个例子!谢谢!
VALUES(sys_guid(),"张三",sysdate)
CREATE TRIGGER "NECAS"."TR_WANUP_INSERT" AFTER
UPDATE OF "STATUS" ON "LOG_WAN" FOR EACH ROW
BEGIN
IF:OLD.STATUS = 2 and :NEW.STATUS = 1 THEN
INSERT INTO LOG_WANUP ("GUID","NEID","PORTID","PORTNAME","PORTNBR","SAMPLINGTIME","DES","CREATEDATE")
VALUES (sys_guid(),:new.GUID,:new.PORTID,:new.PORTNAME,:new.PORTNBR,sysdate,"1",sysdate);
END IF;
END;提示错误如下:行号= 3 列号= 5 错误文本= PL/SQL: SQL Statement ignored
行号= 4 列号= 84 错误文本= PL/SQL: ORA-00984: 列在此处不允许