Home » SQL & PL/SQL » SQL & PL/SQL » :NEW in Trigger
:NEW in Trigger [message #351289] Tue, 30 September 2008 04:09 Go to next message
arjunyadav
Messages: 15
Registered: September 2008
Junior Member
Hi Friends,
I have written a trigger and to get new value we can write like below

:NEW.COLUMN_NAME

but my tables column name is comming from cursor then how can I
mannage it to get the new value in the column. Please Guide me.

Thanks
Arjun
Re: :NEW in Trigger [message #351290 is a reply to message #351289] Tue, 30 September 2008 04:12 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I've no clear idea what you want.
Post some code showing the problem.
Re: :NEW in Trigger [message #351292 is a reply to message #351289] Tue, 30 September 2008 04:14 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Please post what you have tried.
I don't see any trigger code.
And before posting please follow posting
./fa/1707/0/

Regards,
Rajat
Re: :NEW in Trigger [message #351299 is a reply to message #351289] Tue, 30 September 2008 04:34 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And stop rating your own question before any answer comes.
And then rate it ONLY if there is some value.

Regards
Michel
Previous Topic: Need to view the number of users logged in to the database
Next Topic: how to use TO_NUMBER function
Goto Forum:
  


Current Time: Tue Dec 06 12:31:27 CST 2016

Total time taken to generate the page: 0.10644 seconds