Home » SQL & PL/SQL » SQL & PL/SQL » Inline Cursors
icon5.gif  Inline Cursors [message #253478] Tue, 24 July 2007 01:45 Go to next message
Messages: 75
Registered: May 2007
Location: Pune

Is there a concept of inline cursors? Embarassed

Thanking you in advance.
Re: Inline Cursors [message #253487 is a reply to message #253478] Tue, 24 July 2007 02:06 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
Yes there is. Oracle calls it "nested cursor" but a general term is "inline cursor". It is a cursor in the select statement. It returns a ref cursor.

SELECT loc.city
       -- inline cursor below:
     , CURSOR( SELECT country_name 
               FROM   countries 
               WHERE country_id = loc.country_id
              ) ctry
FROM   locations loc

I never really used it.

Edit: link

[Updated on: Tue, 24 July 2007 02:14]

Report message to a moderator

Previous Topic: Sorting Alphanumeric values in Varchar2 column
Next Topic: XML
Goto Forum:

Current Time: Fri Oct 21 17:52:06 CDT 2016

Total time taken to generate the page: 0.23542 seconds