topic Re: Command line arguement for SQLPlus in Operating System - HP-UX

Command line arguement for SQLPlus

Chris Fung — Thu, 08 Aug 2002 05:10:02 GMT

Hi all,

Just wondering if it is possible to pass command line arguement to .sql file?

E.g. SQL> abc.sql 1 2

Just like shell script accepting paramter.

Thanks,

Chris,

Re: Command line arguement for SQLPlus

Kenneth_19 — Thu, 08 Aug 2002 05:15:35 GMT

Yes, you can.

In the SQL script file, similar to shell scripts, instead of using "$1", "$2", ..., replace it with "&1", "&2", ...

If you do not want the &1 or &2 to be definded repeatedly in the subsequent reference inside the sql scripts, use &&1, &&2, ... instead.

Regards,
Kenneth

Re: Command line arguement for SQLPlus

Pierce Byrne_1 — Thu, 08 Aug 2002 06:08:47 GMT

You can also run this via a script
eg
#!/bin/ksh
MYVAR=10
sqlplus user/password << EOF
select count(1)
from mytable m
where m.myrow = $MYVAR
/
EOF

Re: Command line arguement for SQLPlus

Zafar A. Mohammed_1 — Thu, 08 Aug 2002 19:39:06 GMT

You can pass any no. of parameters. Example

!/bin/ksh
echo "Enter Database User Name : \c "
read username
echo "Enter Password : \c "
read password
echo "Enter Employee Name : \c "
read ename

sqlplus -s << SQLEOF
${username}/${password}
SELECT *
FROM EMPLOYEE
WHERE ENAME='${ename}';

SQLEOF

Thanks
Zafar