
December 17th, 2003, 03:31 PM
|
|
Contributing User
|
|
Join Date: Sep 2003
Posts: 68
Time spent in forums: < 1 sec
Reputation Power: 10
|
|
|
Here is what I have on my Unix box:
Within one script, I have:
$ORACLE_HOME/bin/sqlplus /nolog @script/script_name.sql $parameter
and script_name.sql is:
CONNECT user/password@DBname
insert into tableA select * from tableB where file_name = '&1';
DISCONNECT
QUIT
Regards,
Dan
|