IT Community - Software Programming, Web Development and Technical Support

how to retrieve the data after commit statement

This is a discussion on how to retrieve the data after commit statement within the Database Support forums, part of the Web Development category; Hi, Suppose i delete some important records and then commit. Is it possible to retrieve data from DB. Thanks V....


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 03-15-2007, 04:47 AM
vadivelanvaidyanathan vadivelanvaidyanathan is offline
D-Web Genius
 
Join Date: Feb 2007
Posts: 803
vadivelanvaidyanathan is on a distinguished road
Default how to retrieve the data after commit statement

Hi,

Suppose i delete some important records and then commit. Is it possible to retrieve data from DB.

Thanks
V.Vadivelan
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 03-15-2007, 04:58 AM
Murali Murali is offline
D-Web Master
 
Join Date: Feb 2007
Location: India-Chennai.
Posts: 386
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: how to retrieve the data after commit statement

Yes its possible.......

Its a DBA trick to do that on certain situations and conditions.....

Contact your Database Administrator for help..
__________________
-Murali..
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 03-15-2007, 06:06 AM
vadivelanvaidyanathan vadivelanvaidyanathan is offline
D-Web Genius
 
Join Date: Feb 2007
Posts: 803
vadivelanvaidyanathan is on a distinguished road
Default Re: how to retrieve the data after commit statement

Can u provide syntax for this condition.

Thanks
V.Vadivelan
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 03-21-2007, 05:49 AM
Murali Murali is offline
D-Web Master
 
Join Date: Feb 2007
Location: India-Chennai.
Posts: 386
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: how to retrieve the data after commit statement

Hi vadivelanvaidyanathan,


Please refer these links for more information.

FLASHBACK- Oracle9i

FLASHBACK- Oracle10g
__________________
-Murali..
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieve only the Nth row from a table? santhakumar Database Support 6 11-14-2008 05:12 AM
Can we have a commit statement inside a trigger? if no why cant we? Mramesh Database Support 6 09-11-2007 03:08 AM
how to store and retrieve data from cookies hanusoftware ASP and ASP.NET Programming 1 08-09-2007 07:17 AM
How to retrieve SIM card data using j2me? mobilegeek J2ME 0 07-22-2007 10:22 PM
How to enforce Transaction concept (ie: commit,rollback ) from .net web application kingmaker C# Programming 0 07-16-2007 11:15 PM


All times are GMT -7. The time now is 06:04 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0