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

Home » SQL & PL/SQL » Client Tools » How do I see the information before commit?

Show: Today's Messages :: Show 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: 54236
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: 54236
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: 54236
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