Re: Passing String Arguments to SQL*Plus from a Unix Shell
- From: Uwe Küchler <uwe@xxxxxxxxxxxx>
- To: "Nigel Thomas" <nigel_cl_thomas@xxxxxxxxx>
- Date: Thu, 29 Mar 2007 16:35:58 +0200 (CEST)
<quote who="Nigel Thomas">
> $ sqlplus -s nthomas/nthomas <<END
>
>> define 1="'1','2'" define 2="'3','4'" @show_inputs
>> exit END
>>
>
> P1='1','2'
> p2='3','4'
Good idea! I must confess that I used this method in other cases but I was
so stuck in my approach that I didn't think of that. Thanks for showing me
the light. ;-)
Regards,
Uwe
--
http://www.freelists.org/webpage/oracle-l
- References:
- Re: Passing String Arguments to SQL*Plus from a Unix Shell
- From: Nigel Thomas
Other related posts:
- » Passing String Arguments to SQL*Plus from a Unix Shell
- » Re: Passing String Arguments to SQL*Plus from a Unix Shell
- » RE: Passing String Arguments to SQL*Plus from a Unix Shell
- » Re: Passing String Arguments to SQL*Plus from a Unix Shell
- » Re: Passing String Arguments to SQL*Plus from a Unix Shell
- » Re: Passing String Arguments to SQL*Plus from a Unix Shell
- » Re: Passing String Arguments to SQL*Plus from a Unix Shell
- Re: Passing String Arguments to SQL*Plus from a Unix Shell
- From: Nigel Thomas