Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Stupid question
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