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

Home -> Community -> Usenet -> c.d.o.server -> Re: Exec statement

Re: Exec statement

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Wed, 7 Sep 2005 15:48:47 -0400
Message-ID: <11huh1g6drarp5e@corp.supernews.com>


<swapnakrishnan2k_at_gmail.com> a écrit dans le message de news:1126121331.748971.98420_at_f14g2000cwb.googlegroups.com...
> Hi,
>
> Thanks. Is there a way for me to execute scripts from within a script
> that do not use sqlplus statements ?
>
> Thanks,
> Swapna
>

As Sybrand said...

BEGIN
    your statements here;
END;
/

and if you've got only one query, don't bother with begin and end... just use the query text

-- 
Syltrem

http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
Received on Wed Sep 07 2005 - 14:48:47 CDT

Original text of this message

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