Re: Select statement

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 13 Mar 2002 22:06:27 +0100
Message-ID: <omfv8usulsv49s11hifmmjb72rc1t49m4g@4ax.com>

On 13 Mar 2002 11:57:51 -0800, lmontoro_at_adelphia.net (Lu) wrote:

>I'm starting to use oracle and need to create a store procedure that
>displays records. I'm used to SQL Server which is very simple to do
>this. Could some one help me write this procedure using one of the
>oracle table for scott called "Account". Ex: Select * from Account;
>
>Thank you for the help,

You need to read the PL/SQL documentation with respect to REF CURSOR Other than that both Usenet and Internet are flooded with examples.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 13 2002 - 15:06:27 CST