passing unix variable to sqlplus without a file name

UNIX for Advanced & Expert Users
1

Hi,
I want to input unix variable to sqlplus.The following is working fine
sqlplus username/password @dummy.sql param1 param2 << EOF
create user $1 identified by $2;
EOF

But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that??

Thanks
sakthi

2

replace $ by && :confused:

3

I tried that &&;
sqlplus -s -L $dbausername/$dbapwd $1 $password <<EOF
create user &&1 identified by &&2;
grant create session to &&1;
exit;
EOF[FONT=Courier New]

Still ,it's giving some errors...

Can someone help me??
Thanks

4

I got it ...
--- $1 $password already there..
sqlplus -s -L $dbausername/$dbapwd <<EOF
create user $1 identified by $password;
grant create session to $1;
exit;
EOF

Simple Naaa...Some times these small things we ll spend more times :eek: