Command to show SQL commands from buffer

Which command displays the SQL command in the SQL buffer, and then executes it?

Showing Answers 1 - 10 of 10 Answers

rudresh kumar

  • Oct 7th, 2005
 

"/ " can also be used for the same

  Was this answer useful?  Yes

Bala

  • Jul 26th, 2006
 

Run command, It's a SQL*PLUS Command

Synonym of RUN is R

  Was this answer useful?  Yes

csbhaskar

  • Mar 13th, 2008
 

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

hemant.agarwal03

  • Mar 17th, 2008
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions