iSQL*Plus User's Guide and Reference Release 9.0.1 Part Number A88826-01 |
|
Command Reference, 27 of 38
R[UN]
Lists and executes the SQL command or PL/SQL block currently stored in the SQL buffer.
RUN causes the last line of the SQL buffer to become the current line.
The slash command (/) functions similarly to RUN, but does not list the command in the SQL buffer on your screen.
Assume the SQL buffer contains the following query:
SELECT DEPARTMENT_ID FROM EMP_DETAILS_VIEW WHERE SALARY>12000
To RUN the query, enter
RUN 1 SELECT DEPARTMENT_ID 2 FROM EMP_DETAILS_VIEW 3* WHERE SALARY>12000 DEPARTMENT_ID ------------- 90 90 90 80 80 20 6 rows selected.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|