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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Stupid question

Re: Stupid question

From: Richard Foote <Richard.Foote_at_oracle.com>
Date: Thu, 08 Aug 2002 18:03:14 +1000
Message-ID: <3D5225C2.D497F687@oracle.com>


Hi There,

Whichever is the standard method in your organisation.

It makes no difference otherwise.

Regards

Richard

s Lehaire wrote:
>
> Hi,
> In PL/SQL what is the difference between IS an AS in a declaration of a
> procedure.
> When I create a procedure (under visual c++) the procedure is define like
> this :
> CREATE /*OR REPLACE*/ PROCEDURE /*PROCEDURE_NAME*/
> AS
> BEGIN
> RETURN;
> END;
>
> but when I read a book the declaration is :
> PROCEDURE Ze_procedure
> IS
> declaration
> BEGIN
> blahblah
> EXCEPTION
> blahblah
> END;
>
> so what is the best way to declare my procedure in Oracle 9i


Received on Thu Aug 08 2002 - 03:03:14 CDT

Original text of this message

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