Home » SQL & PL/SQL » SQL & PL/SQL » Database Triggers (merged)
Database Triggers (merged) [message #346444] Mon, 08 September 2008 10:32 Go to next message
sridharvv
Messages: 3
Registered: September 2008
Junior Member
Hi

I need help to create DB trigger. I need to maintain different versions when I update records through database.

For each financial year I will be having 12 records. If I update one or more than one record for that particular year then the updated records as well as non updated records should go into audit table and the sequence for those 12 records should be unique.

Thanks
Re: Database Triggers [message #346445 is a reply to message #346444] Mon, 08 September 2008 10:33 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Re: Database Triggers [message #346446 is a reply to message #346444] Mon, 08 September 2008 10:34 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
Auditing Trigger Example

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm#ABC1032282
DB Triggers [message #346453 is a reply to message #346444] Mon, 08 September 2008 10:49 Go to previous messageGo to next message
sridharvv
Messages: 3
Registered: September 2008
Junior Member
Hi

I need help to create DB trigger. I need to maintain different versions when I update records through database.

For each financial year I will be having 12 records. If I update one or more than one record for that particular year then the updated records as well as non updated records should go into audit table and the sequence for those 12 records should have same number.


Thanks
Re: DB Triggers [message #346454 is a reply to message #346453] Mon, 08 September 2008 10:51 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
Why Post twice?
http://www.orafaq.com/forum/t/124542/126128/
Re: DB Triggers [message #346455 is a reply to message #346453] Mon, 08 September 2008 10:56 Go to previous message
sridharvv
Messages: 3
Registered: September 2008
Junior Member
In my first post I mentioned seq should be unqique. In fact should have same seq for that 12 records.

exampe

2008 1 1
2008 2 1
2008 3 1
2008 4 1
2008 5 1
2008 6 1
........
2008 12 1



2008 1 2
2008 2 2
2008 3 2
2008 4 2
2008 5 2
2008 6 2
........
2008 12 2


Previous Topic: ORA:01732
Next Topic: Files names and structure
Goto Forum:
  


Current Time: Thu Dec 08 18:32:26 CST 2016

Total time taken to generate the page: 0.05112 seconds