Home » SQL & PL/SQL » SQL & PL/SQL » Trigger For insert as well as update
Trigger For insert as well as update [message #210015] Mon, 18 December 2006 23:12 Go to next message
hm_harshad
Messages: 1
Registered: June 2006
Junior Member
i have a table, in which i want that whenevr i insert into its primary key column, there is another column called as SRLNO (for serial no), it should get update with the max of serial no + 1.

Report message to a moderator

Re: Trigger For insert as well as update [message #210075 is a reply to message #210015] Tue, 19 December 2006 04:37 Go to previous message
rameshuddaraju
Messages: 69
Registered: June 2005
Location: India
Member
With out primary key value you can not create a row.
So, use a sequence for SRLNO (for serial no) column.

Report message to a moderator

Previous Topic: problem with cursor
Next Topic: scheduling a task
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 06 13:34:26 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.