Filter
Top Products
dn 1500
sal 80000.00
SQL>
For the syntax of the RESET PARAM command, see the “RESET PARAM Command” (page 99).
Executing a Prepared SQL Statement
To execute a prepared SQL statement, use the EXECUTE statement.
For example, this EXECUTE statement executes the prepared empsal statement, which does
not have any parameters:
SQL>execute empsal;
SALARY
----------
137000.10
90000.00
75000.00
138000.40
56000.00
136000.00
80000.00
70000.00
175500.00
90000.00
118000.00
--- 11 row(s) selected.
SQL>
This EXECUTE statement executes the prepared empcom statement, which has one named
parameter, ?dn, which was set by SET PARAM for the department number:
SQL>execute empcom;
FIRST_NAME LAST_NAME DEPTNUM
--------------- -------------------- -------
ALAN TERRY 3000
DAVID TERRY 2000
PETE WELLINGTON 3100
JOHN CHOU 3500
MANFRED CONRAD 4000
DINAH CLARK 9000
DAVE FISHER 3200
GEORGE FRENCHMAN 4000
KARL HELMSTED 4000
JOHN JONES 4000
JOHN HUGHES 3200
WALTER LANCASTER 4000
MARLENE BONNY 4000
BILL WINN 2000
MIRIAM KING 2500
GINNY FOSTER 3300
MARIA JOSEF 4000
HERB ALBERT 3300
RICHARD BARTON 1000
XAVIER SEDLEMEYER 3300
DONALD TAYLOR 3100
LARRY CLARK 1000
JIM HERMAN 3000
GEORGE STRICKER 3100
OTTO SCHNABL 3200
TIM WALKER 3000
62 Running Commands Interactively in the Neoview Script Interface