OraFAQ Forum: SQL & PL/SQL » Append mode with REF CURSOR?!

Home » SQL & PL/SQL » SQL & PL/SQL » Append mode with REF CURSOR?!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Append mode with REF CURSOR?! [message #221486]

Tue, 27 February 2007 02:42

fortunethiyagu
Messages: 94
Registered: December 2006

Member

Hi friends,

Is it possible to append the REF CURSOR?

-thiyagarajan palanisamy

Report message to a moderator

Re: Append mode with REF CURSOR?! [message #221523 is a reply to message #221486]

Tue, 27 February 2007 05:23

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?

Report message to a moderator

Re: Append mode with REF CURSOR?! [message #221542 is a reply to message #221486]

Tue, 27 February 2007 06:37

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

Report message to a moderator

Re: Append mode with REF CURSOR?! [message #221643 is a reply to message #221542]

Tue, 27 February 2007 21:46

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

Report message to a moderator

Re: Append mode with REF CURSOR?! [message #222238 is a reply to message #221643]

Fri, 02 March 2007 07:36

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

Report message to a moderator

Previous Topic:	loading comma seperated values through sql loader
Next Topic:	Outter join in IN clause ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 07:27:06 CST 2024