GeekInterview.com
Series: Subject: Topic:
Question: 211 of 216

Command to show SQL commands from buffer

Which command displays the SQL command in the SQL buffer, and then executes it?
Asked by: Interview Candidate | Asked on: Mar 6th, 2005
Showing Answers 1 - 10 of 10 Answers
rudresh kumar

Answered On : Oct 7th, 2005

"/ " can also be used for the same

  
Login to rate this answer.
geekspv

Answered On : Oct 31st, 2005

View all answers by geekspv

Uset the LIST or L command to get the recent one from SQL Buffer

  
Login to rate this answer.
geekspv

Answered On : Oct 31st, 2005

View all answers by geekspv

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.
mehraban_b

Answered On : Mar 14th, 2007

View all answers by mehraban_b

/

  
Login to rate this answer.
Gleam

Answered On : Oct 26th, 2007

View all answers by Gleam

Can anyone illustrate this with an example?

  
Login to rate this answer.
sampra

Answered On : Feb 13th, 2008

View all answers by sampra

we can use / command

  
Login to rate this answer.
csbhaskar

Answered On : Mar 13th, 2008

View all answers by csbhaskar

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

Yes  2 Users have rated as useful.
  
Login to rate this answer.
hemant.agarwal03

Answered On : 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.

  
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

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

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.