Re: Stored Procedure Syntax

Scott Metro wrote:
>
> Hi,
> I am transitioning from Sybase to Oracle and haven't received my help
> manual yet. The syntax for creating stored procedures seems to be quite
> different from Sybase. Can someone please tell me what the syntax would be
> to create a stored procedure that simply executes the following SQL:
>
> SELECT * FROM EMPLOYEE;
>
> In Sybase it would simply be:
>
> create PROCEDURE USP_TEST ( )
> AS SELECT * FROM EMPLOYEE;
  CREATE PROCEDURE USP_TEST IS
  BEGIN
       SELECT * FROM EMPLOYEE;
  END

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841