| Previously executed block [message #481587] |
Thu, 04 November 2010 07:51  |
pointers
Messages: 451
Registered: May 2008
|
Senior Member |
|
|
Hi,
Can you please tell, is there a way to get previously executed block of code from sql*plus (command line) not using arrow keys.
I am using windows command line to do this.
I have executed a block of code ( anonymous block) which got to have 40 lines of code, after which I have executed some other commands. Now i need to get the code of the block (40 lines) which i executed.
Is there a way to do this.
Regards,
Pointers
|
|
|
|
|
|
| Re: Previously executed block [message #481597 is a reply to message #481587] |
Thu, 04 November 2010 08:33  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote: have executed a block of code ( anonymous block) which got to have 40 lines of code, after which I have executed some other commands. Now i need to get the code of the block (40 lines) which i executed.
SQL> begin
2 null;
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> l
1 begin
2 null;
3* end;
You can get it only JUST after execution as you can get ONLY the last one.
Regards
Michel
[Updated on: Thu, 04 November 2010 08:34] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
