Re: Stored Procedure Syntax

[Quoted] create or replace PROCEDURE USP_TEST ( ) AS
begin

        SELECT * FROM EMPLOYEE
end ;
On Wed, 5 Feb 1997 15:08:38 GMT, "Scott Metro" <smetro_at_world.std.com> 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;
>
>Any help is greatly appreciated!
>
>Scott
>smetro_at_world.std.com
>
Received on Thu Feb 06 1997 - 00:00:00 CET