yogesh

• Jan 18th, 2006

 

i think u can query for max(rowid).

Anu

• Feb 6th, 2006

 

You can get the newly entered row in oracle using this query.. I dont know using triggers.Let me know if someone gets it. select sno,sname from dup_rows where rowid = (select max(rowid) from dup_rows);

Anu

• Feb 6th, 2006

 

You can get the newly entered row in oracle using this query.. I dont know using triggers.Let me know if someone gets it. select sno,sname from dup_rows where rowid = (select max(rowid) from dup_rows);

sudeep_srivastava

• Jun 19th, 2007

 

In Trigger there is a special Table Called INSERTD. it takes the value from transation log.

In the After Insert Trigger....

SELECT Id,Name FROM INSERTED

you can catch these values in a variable.