Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NEW.columnname

Status
Not open for further replies.
FoxJunior

FoxJunior

MIS
May 27, 2002
12
ID
Hi All, i'm a new user of oracle, i use oracle 8i.
I have a statement in my trigger, the trigger is like this:

SELECT * FROM employee WHERE :new.empno = empno

I don't understad what the meaning about 'new' above. Can you explain it for me?

Thanx a lot...
 
Sort by date Sort by votes
the :new is a keyword used in triggers to point to the new row or latest row.
If ur inserting in the employee table a new row with empno =100 then
:new.empno takes the value as 100

pretty fundamental stuff ...check out technet.oracle.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top