select * from table where rownum<(select count(*)+1 from table) minus select * from table where rownum<(select count(*) from table);不知道行不行
1.在USER1.TEST表中增加一字段GETTIME; 2.在USER1用户下建立触发器: CREATE OR REPLACE TRIGGER USER1_TRI.TEST_AI AFTER INSERT ON TEST FOR EACH ROW DECLARE BEGIN :NEW.GETTIME := SYSDATE; END USER1_TRI.TEST_AI; 3.查询刚才插入的那一行数据: SELECT * FROM TEST WHERE GETTIME =(SELECT MAX(GETTIME) FROM TEST)。
2.在USER1用户下建立触发器:
CREATE OR REPLACE TRIGGER USER1_TRI.TEST_AI AFTER
INSERT ON TEST
FOR EACH ROW
DECLARE
BEGIN
:NEW.GETTIME := SYSDATE;
END USER1_TRI.TEST_AI;
3.查询刚才插入的那一行数据:
SELECT * FROM TEST WHERE GETTIME =(SELECT MAX(GETTIME) FROM TEST)。
不切实际就不用想太多了,还是与dba讨论建立触发器吧.