RE: Passing String Arguments to SQL*Plus from a Unix Shell

From: David Moss <David.Moss_at_fdmgroup.com>
Date: Thu, 29 Mar 2007 12:09:01 +0100
Message-ID: <39132CDDC017F3459FFD0F26B3F8A09F1D9BA0@fdm-mail01.fdmgroup.local>

try

---

$ echo "'1','2','3'"
'1','2','3'

$ echo "\"'1','2','3'\""
"'1','2','3'"

---

maybe?

Dave.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Uwe Küchler Sent: Thu 29/03/2007 11:06
To: oracle-l_at_freelists.org
Subject: Passing String Arguments to SQL*Plus from a Unix Shell  

Hi all,

I've scanned this list and other forums but haven't found a satisfying answer so far:
I need to pass arguments containing the SQL string delimiter "'" to sqlplus from a shell script, e.g.:

sqlplus user/pass @my.sql $1

where $1 should be like "'1','2','3'", so that a SQL statement WHERE clause within the script can be modified like this:

define inlist=&1
...
SELECT something FROM mytable
 WHERE something NOT IN ( &inlist );

-->

WHERE mycol NOT IN ( '1','2','3' );

I know how to pass arguments/parameters without the "'", but when I use "'" it gets erased by the shell. I've tried to escape the "'" but with no success so far.
It looks so simple but I can't find a solution. *help*

Regards,
--==/ Uwe \==--

--
http://www.freelists.org/webpage/oracle-l



________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________



This message is from FDM Group Plc, and may contain information that is confidential or privileged.  If you are not the intended recipient, please delete the message and any attachments and notify the sender.  This email is not intended to create legally binding commitments on behalf of FDM Group Plc, nor do its contents reflect the corporate views or policies of FDM.  Any unauthorised disclosure, use or dissemination, either whole or partial, is prohibited. FDM Group Plc is a private limited company registered in England (Reg. No. 2542980).


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 29 2007 - 06:09:01 CDT