rudresh kumar
Answered On : Oct 7th, 2005
"/ " can also be used for the same
Login to rate this answer.
Uset the LIST or L command to get the recent one from SQL Buffer
Login to rate this answer.
Uset the LIST or L command to get the recent one from SQL Buffer
Login to rate this answer.
Bala
Answered On : Jul 26th, 2006
Run command, It's a SQL*PLUS Command
Synonym of RUN is R
Login to rate this answer.
/
Login to rate this answer.
Can anyone illustrate this with an example?
Login to rate this answer.
we can use / command
Login to rate this answer.
The answer is RUN, R or RU.
******************************************************************
IMPORTANT NOTE
******************************************************************
'/' will only execute the last sql statement stored in the buffer and will not display it.
LIST, LIS, LI or L will list (Display) the sql statement stored in the buffer but will not execute.
EDIT, EDI or ED will allow you to edit the sql code in an external text editor
----------------------------------------------------------------------------------------------------------
RUN, LIST and EDIT are SQL*Plus commands. For their usage and meaning you can refer to http://www.rdbprime.com/Oracle/Oracle_Docs/Oracle9iDB_Server/server.920/a90842/ch13.htm

2 Users have rated as useful.
Login to rate this answer.
LIST and L is correct but you can also type "ED" also on sqlplus window and enter, it will open a notepad window for you to edit (if you required) otherwise you can press ALT + F4 and ENTER key.
Login to rate this answer.
RUN Command...... Check by following example
SQL> select sysdate from dual;
SYSDATE
---------
03-FEB-11
SQL> run
1* select sysdate from dual
SYSDATE
---------
03-FEB-11

1 User has rated as useful.
Login to rate this answer.