View previous topic :: View next topic
|
Author |
Message |
bibek24
New User
Joined: 14 Aug 2007 Posts: 35 Location: Hyderabad
|
|
|
|
Hi all,
Can a dynamic array be set for a query which fetches a single column values from a table?
If it is possible how this can be used as a predicate in some other query?
Appreciate your help!!! |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
I'm sure your question is quite clear to you - it may not be as clear to others who read it.
If you post an example of what you have in mind, someone may have a suggestion. |
|
Back to top |
|
|
bibek24
New User
Joined: 14 Aug 2007 Posts: 35 Location: Hyderabad
|
|
|
|
Let me elaborate the scenario...
I have a query which returns multiple Account Ids.
Using a cursor, it can be stored in a host variable but I need a host array to store the values.
Later on I need to use the host array as one of the predicates in the some other query.
Is it possible? |
|
Back to top |
|
|
|