OraFAQ Forum: SQL & PL/SQL » How to mainatin history of table.

Home » SQL & PL/SQL » SQL & PL/SQL » How to mainatin history of table.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to mainatin history of table. [message #609727]

Tue, 11 March 2014 09:30

na.dharma@gmail.com
Messages: 82
Registered: May 2008
Location: bangalore

Member

Hi..

I want to maintain history of table in oracle pl sql with using trigger. Can anybody please let me know how I can maintain history of table.?

Thanks in advance.
Dev Sad

Report message to a moderator

Re: How to mainatin history of table. [message #609730 is a reply to message #609727]

Tue, 11 March 2014 09:34

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is a FAQ, you can Google for it, I'm pretty sure you will get the code.

Report message to a moderator

Re: How to mainatin history of table. [message #609731 is a reply to message #609730]

Tue, 11 March 2014 09:37

na.dharma@gmail.com
Messages: 82
Registered: May 2008
Location: bangalore

Member

Hi,

I had tried it but unable to find any relevant code or suggestion Sad

Do you have any code or suggestion on it..?

Thanks..

Report message to a moderator

Re: How to mainatin history of table. [message #609733 is a reply to message #609731]

Tue, 11 March 2014 09:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.lmgtfy.com/?q=ORACLE+audit+table+changes

Report message to a moderator

Re: How to mainatin history of table. [message #609734 is a reply to message #609731]

Tue, 11 March 2014 09:50

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

For instance (out of many): Triggers to create a history row on update

Report message to a moderator

Re: How to mainatin history of table. [message #609736 is a reply to message #609734]

Tue, 11 March 2014 09:54

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Or this: PL SQL trigger to insert history record when a column is updated

Report message to a moderator

Re: How to mainatin history of table. [message #609737 is a reply to message #609731]

Tue, 11 March 2014 09:55

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

Look up the Flashback Data Archive capability.

Report message to a moderator

Previous Topic:	sending email outsude the domain via database
Next Topic:	Initialisation of private variable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:47:32 CDT 2024