Home » SQL & PL/SQL » Client Tools » How do I see the information before commit?
icon6.gif  How do I see the information before commit? [message #578087] Sun, 24 February 2013 07:16 Go to next message
ashishpatel1992
Messages: 38
Registered: February 2013
Location: India
Member
I want to see the pending operations before commit.
How can I view what operations are going to commit when I enter the commit.
Regards,
Ashish
Re: How do I see the information before commit? [message #578094 is a reply to message #578087] Sun, 24 February 2013 07:56 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
What is the actual problem you are trying to solve?

Regards
Michel
Re: How do I see the information before commit? [message #578096 is a reply to message #578094] Sun, 24 February 2013 07:59 Go to previous messageGo to next message
ashishpatel1992
Messages: 38
Registered: February 2013
Location: India
Member
For Example I have inserted 5 records inside emp table & I haven't commited it yet.
And I have done
cl scr

so the previous records details are gone.
How I can see the records in buffer?
Re: How do I see the information before commit? [message #578104 is a reply to message #578096] Sun, 24 February 2013 08:11 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You clear the buffer, there is no line buffer in Windows SQL*Plus, you should use DOS SQL*Plus if you want to see the buffer using the up arrow (in the limit of the DOS property you gave on your DOS window).

Regards
Michel
Re: How do I see the information before commit? [message #578111 is a reply to message #578104] Sun, 24 February 2013 08:21 Go to previous messageGo to next message
ashishpatel1992
Messages: 38
Registered: February 2013
Location: India
Member
I am using SQL Plus when I move the key up it shows.
I just wanted to know if there is alternative option to see the previously executed statements after i perform
SQL> cl scr
Re: How do I see the information before commit? [message #578116 is a reply to message #578111] Sun, 24 February 2013 08:26 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Please read the link on SQL*Plus manual I gave in another of your topics.
You cannot learn Oracle and how to use it without reading the documentation.

Regards
Michel
Re: How do I see the information before commit? [message #582444 is a reply to message #578116] Thu, 18 April 2013 07:17 Go to previous messageGo to next message
gazzag
Messages: 275
Registered: November 2010
Location: Bristol, UK
Senior Member
If you're using SQL*Plus in a DOS box, use F7 to bring up the command history.

HTH
-g
Re: How do I see the information before commit? [message #583358 is a reply to message #578111] Tue, 30 April 2013 02:18 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
How about:
l

LIST command


This doesn't really have anything to do with committing, though.
Previous Topic: How to display chines characters in sql developer
Next Topic: ORA-12505 TNS:listener does not currently know of SID given in connect descriptor
Goto Forum:
  


Current Time: Fri Jul 25 04:18:38 CDT 2014

Total time taken to generate the page: 0.09267 seconds