Re: Dumb Q but I need to Know

From: Chetan Wagle <chetanw_at_yahoo.com>
Date: Thu, 23 Sep 1999 11:01:10 +0530
Message-ID: <7scds8$8j7$1@herald.ctp.com>

Hi IIFThen,

In Oracle ( I don't know much of SQL Server), in PL/SQL you cannot select
> 1 rows from a table at a time. If you have a query that does so, you must
declare a cursor for it and store the retreived values from each row into the cursor variables and you need to loop thru the cursor contents for each row.

Check out any beginners book on PL/SQL.

HTH,
Chetan
Bangalore, India

IIFThen wrote in message ...
>I'm trying to write a simple select query within an Oracle stored procedure
>using the following syntax:
>
>select * from <tablename> where <condition statement>
>
>It's compiling with errors. How do I rectify this for Oracle SP. I guess
>I've been with MS SQL Server SP way of doing things. Can anyone out there
>help me out. Thank you.
>--
>IIFThen
>
>
Received on Thu Sep 23 1999 - 00:31:10 CDT