Re: Select statement

From: damorgan <damorgan_at_exesolutions.com>
Date: Wed, 13 Mar 2002 22:02:46 GMT
Message-ID: <3C8FCC88.93870AC8@exesolutions.com>

Please do yourself a favor, us too, and forget everything you know about SQL Server, how it does things, and how you did things in SQL Server. This is Oracle and the similarities are only skin deep.

You will need to use a REF CURSOR.

And you need to purchase Tom Kyte's book "expert one-on-one Oracle" and read up on the differences in multiversioning, transactions, locking, temp tables, and countless other things.

Daniel Morgan

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,
Received on Wed Mar 13 2002 - 16:02:46 CST