Data Access - How to find that when and which record inserted in the table ?

GeekInterview.com > Interview Questions > Oracle > Data Access

Go To First | Previous Question | Next Question

Data Access | Question 24 of 27

How to find that when and which record inserted in the table ?

Total Answers and Comments: 3

Last Update: June 11, 2009 Asked by: vijay

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 03, 2007 06:36:01

joybanerjee

Member Since: November 2007 Contribution: 19

RE: How to find that when and which record inserted in the table ?

you can write an after insert trigger to maintain the audit of that table.

Is this answer useful? Yes | No

June 10, 2009 05:02:15

MaheshRamekar

Member Since: June 2009 Contribution: 3

RE: How to find that when and which record inserted in the table ?

Using Log miner

Is this answer useful? Yes | No

June 11, 2009 01:21:37

dj_dj_dj

Member Since: May 2009 Contribution: 12

RE: How to find that when and which record inserted in the table ?

Most simple way is to write an Insert trigger on the table which you want to get audited.

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank