After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Are you looking for a
Jersey Girl T-Shirt
?
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent Friday fish fry!
|
Oracle
»
PL-SQL
»
SQL-Plus
»
Parameters-Pass
Passing parms to a SQL script via SQL-Plus
SQLPLUS allows dynamic variable substitution, from the command line.
Here's an example:
-- test1.sql
select count(1) from invoices where region=&1 ;
exit
-- Then, to run the SQL with the parm CANADA ..
os-prompt> sqlplus scott/tiger@myserver @test1.sql CANADA
Try running the SQL without that last parm - you will be prompted to key in the variable!
|
|
|
|
