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
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.
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
Messages: 69
Registered: June 2005
Location: India

With out primary key value you can not create a row.
So, use a sequence for SRLNO (for serial no) column.
Previous Topic: Clearing Redo logs
Next Topic: tnsnames.ora and listener.ora
Goto Forum:

Current Time: Sat Aug 19 15:36:25 CDT 2017

Total time taken to generate the page: 0.01846 seconds