Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SqlPlus batch

Re: SqlPlus batch

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 15 Jul 2005 20:34:56 -0700
Message-ID: <1121484898.231140@yasure>


ciccio wrote:
> Noel wrote:
>
> Wow! Faster than the speed of light!
>

>> Enclose it in <declare begin end> block.
>> declare
>>   x integer;
>>   y varchar2(2000);
>>   begin
>>    myproc(sysdate - 10, sysdate, 1, x, y);
>>   end;
>> /

>
>
> and to dump x and y values?
>
> Thanks

INSERT INTO t ....

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Jul 15 2005 - 22:34:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US