Stored Procedure Syntax
From: Scott Metro <smetro_at_world.std.com>
Date: 1997/02/05
Message-ID: <01bc1375$f4915d80$0f02000a_at_metros>#1/1
Date: 1997/02/05
Message-ID: <01bc1375$f4915d80$0f02000a_at_metros>#1/1
Hi,
[Quoted] [Quoted] I am transitioning from Sybase to Oracle and haven't received my help
[Quoted] 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 Wed Feb 05 1997 - 00:00:00 CET