Home » SQL & PL/SQL » SQL & PL/SQL » Query a data inside a cursor (merged 4)
icon3.gif  Query a data inside a cursor (merged 4) [message #417076] Wed, 05 August 2009 23:59 Go to next message
pradeep2002gs
Messages: 19
Registered: August 2009
Junior Member
hi all
i like to know is it possible to query a data that resides in a cursor which is already a data fetched by another query and stored in a cursor
eg:
cur1 as select * from emp1

now can i query cur1 and fetch data with conditions very similar to query...?
thanks in advance
Re: Query a data inside a cursor [message #417081 is a reply to message #417076] Thu, 06 August 2009 00:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>now can i query cur1 and fetch data with conditions very similar to query...?
YES
Re: Query a data inside a cursor [message #417083 is a reply to message #417081] Thu, 06 August 2009 00:13 Go to previous messageGo to next message
pradeep2002gs
Messages: 19
Registered: August 2009
Junior Member
hi BlackSwan

thanks for the reply can i find few links related to that..?
Re: Query a data inside a cursor (merged 4) [message #417088 is a reply to message #417076] Thu, 06 August 2009 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
i like to know is it possible to query a data that resides in a cursor which is already a data fetched by another query and stored in a cursor

Not clear.

Quote:
now can i query cur1 and fetch data with conditions very similar to query...?

What does this mean?

Post a clear example.

Please read OraFAQ Forum Guide.
Also always post your Oracle version with 4 decimals.

Regards
Michel
Re: Query a data inside a cursor (merged 4) [message #417113 is a reply to message #417088] Thu, 06 August 2009 02:32 Go to previous messageGo to next message
bonker
Messages: 402
Registered: July 2005
Senior Member
Cursor is just a pointer and it does not store the data.

[Updated on: Thu, 06 August 2009 02:34]

Report message to a moderator

Re: Query a data inside a cursor (merged 4) [message #417159 is a reply to message #417076] Thu, 06 August 2009 05:52 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you mean 'Can I write a query that uses CUR1 as a data source' then I believe that answer is No.

Previous Topic: ORACLE AND SQL SERVER (migration)
Next Topic: sql query to find fourdays before the current date excluding weekends
Goto Forum:
  


Current Time: Thu Nov 14 04:58:09 CST 2024