PL-SQL: Cursor definition with additional parameter ? reason/meaning ?
From: Werner Mueller <Werner2_at_mail.org>
Date: 22 Feb 2007 21:12:04 GMT
Message-ID: <45de0724$0$6404$9b4e6d93_at_newsspool2.arcor-online.net>
I learned that a cursor definition in PL-SQL follows the schema:
Date: 22 Feb 2007 21:12:04 GMT
Message-ID: <45de0724$0$6404$9b4e6d93_at_newsspool2.arcor-online.net>
I learned that a cursor definition in PL-SQL follows the schema:
Curosr mycurosr is ...
Now I found a couple of sample where the cursor definition is like
Cursor mycursor (somevar VARCHAR2) is ....
What does that parameter/variable defintion mean ? Sometimes even more 2 or 3 additional vars are defiend
How can I use this variable.
May I get an example on how to apply such a parameter.
Werner Received on Thu Feb 22 2007 - 22:12:04 CET