Home » SQL & PL/SQL » SQL & PL/SQL » Append mode with REF CURSOR?!
Append mode with REF CURSOR?! [message #221486] Tue, 27 February 2007 02:42 Go to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Hi friends,

Is it possible to append the REF CURSOR?

-thiyagarajan palanisamy
Re: Append mode with REF CURSOR?! [message #221523 is a reply to message #221486] Tue, 27 February 2007 05:23 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Do you mean Append TO a Ref Cursor, or Append a Ref Cursor TO something?
Re: Append mode with REF CURSOR?! [message #221542 is a reply to message #221486] Tue, 27 February 2007 06:37 Go to previous messageGo to next message
gintsp
Messages: 118
Registered: February 2007
Senior Member
In case you are thinking about hint append, then no, because cursors mean row by row operations and it is working only for insert into ... select from...

But of course as previous poster said it is not clear what is not clear for you. Smile

Gints Plivna
http://www.gplivna.eu
icon10.gif  Re: Append mode with REF CURSOR?! [message #221643 is a reply to message #221542] Tue, 27 February 2007 21:46 Go to previous messageGo to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Thanx yaar...

Actualy i want to append the ref cursor ie.. row by row...based on id's. For 1st ID i will get 5 records, and for 2nd other set of records...so on..while returning i have to bundle all records to end user application.

I have done the same by using GLOBAL TEMP TABLE.I guess this is the only way to achive.

Is there any other alternative?

-thiyagarajan palanisamy
Re: Append mode with REF CURSOR?! [message #222238 is a reply to message #221643] Fri, 02 March 2007 07:36 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Something like that:
SELECT * FROM source
WHERE source.id IN (
  SELECT id FROM id_source)


Gints Plivna
http://www.gplivna.eu
Previous Topic: loading comma seperated values through sql loader
Next Topic: Outter join in IN clause ?
Goto Forum:
  


Current Time: Sat Dec 03 12:20:56 CST 2016

Total time taken to generate the page: 0.08485 seconds