OraFAQ Forum: Client Tools » How do I see the information before commit?

Home » Other » Client Tools » How do I see the information before commit?

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

How do I see the information before commit? [message #578087]

Sun, 24 February 2013 07:16

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

Report message to a moderator

Re: How do I see the information before commit? [message #578094 is a reply to message #578087]

Sun, 24 February 2013 07:56

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

Senior Member
Account Moderator

No.
What is the actual problem you are trying to solve?

Regards
Michel

Report message to a moderator

Re: How do I see the information before commit? [message #578096 is a reply to message #578094]

Sun, 24 February 2013 07:59

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?

Report message to a moderator

Re: How do I see the information before commit? [message #578104 is a reply to message #578096]

Sun, 24 February 2013 08:11

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: How do I see the information before commit? [message #578111 is a reply to message #578104]

Sun, 24 February 2013 08:21

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

Report message to a moderator

Re: How do I see the information before commit? [message #578116 is a reply to message #578111]

Sun, 24 February 2013 08:26

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: How do I see the information before commit? [message #582444 is a reply to message #578116]

Thu, 18 April 2013 07:17

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

If you're using SQL*Plus in a DOS box, use F7 to bring up the command history.

HTH
-g

Report message to a moderator

Re: How do I see the information before commit? [message #583358 is a reply to message #578111]

Tue, 30 April 2013 02:18

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

How about:

LIST command

This doesn't really have anything to do with committing, though.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:12:23 CDT 2024