Re: cursor syntax question
From: <sybrandb_at_hccnet.nl>
Date: Thu, 01 Oct 2009 16:19:15 +0200
Message-ID: <lie9c5dpfhi8v9p97pubsu2o81ktn40nmo_at_4ax.com>
On Thu, 1 Oct 2009 06:42:29 -0700 (PDT), kes <abirch_at_gmail.com> wrote:
Date: Thu, 01 Oct 2009 16:19:15 +0200
Message-ID: <lie9c5dpfhi8v9p97pubsu2o81ktn40nmo_at_4ax.com>
On Thu, 1 Oct 2009 06:42:29 -0700 (PDT), kes <abirch_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
>
>Best,
>Alex
>
>~~~~
>http://www.lifesabirch.org
http://www.psoug.org/reference/datatypes.html
-- -- Sybrand Bakker Senior Oracle DBAReceived on Thu Oct 01 2009 - 09:19:15 CDT