Re: Help on Paramater Passing

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 06 Mar 2006 21:30:12 +0100
Message-ID: <dui5cb$g0$1@news5.zwoll1.ov.home.nl>

amerar_at_iwc.net wrote:
> Nice, I just have to find an example so I can learn how to do
> this....... :)
>

sqlplus uid/passwd @myproc name_proc

myproc.sql then would use &1
goes up to nine parameters:

test.sql contains:
select &1 from dual
/
[oracle10_at_csdb01 oracle10]$ sqlplus scott/tiger @test 12

SQL*Plus: Release 10.1.0.4.0 - Production on Mon Mar 6 21:16:51 2006

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options

old 1: select &1 from dual
new 1: select 12 from dual

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Mon Mar 06 2006 - 14:30:12 CST