Re: cursor syntax question

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 01 Oct 2009 18:35:44 +0200
Message-ID: <7ik430F31ompuU1_at_mid.individual.net>

On 10/01/2009 04:25 PM, Mark D Powell wrote:
> On Oct 1, 9:42 am, kes <abi..._at_gmail.com> wrote:

>> I've looked in Oracle PL/SQL 3rd Edition and searched psoug.org but I
>> was unable to determine:
>> CURSOR foo (vbar varchar2) IS
>> select *
>> from table_t t
>> where t.bar = vbar;
>>
>> I get that vBar is a varchar2, but what does it mean exactly? If you
>> could send me a pointer to any documentation this would be greatly
>> appreciated. This code was found in Oracle 10.2

> Alex, while Sybrand gave you a link to data type information posted
> the same site you were found your cursor reference on I though you
> might want to also reference the online official Oracle
> documentation. Here is the site url: http://tahiti.oracle.com
>
> You can find cursors in the PL/SQL manual and data types are defined
> in both the Concepts and Application Developers Guide - Fundamentals
> manuals.

I'd like to add that often no explicit cursor declaration is necessary, e.g.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/sqloperations.htm#sthref1360

Kind regards

        robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Received on Thu Oct 01 2009 - 11:35:44 CDT