populate_group_with_query

[dau...@hotmail.com]

Hi

I would to know if it is possible to a sub-select statement in the
select statement of POPULATE_GROUP_WITH_QUERY.

This is the code I am trying to write but not sure how.

status := POPULATE_GROUP_WITH_QUERY('LISTDEL_REC',
'select col1, col2 from table1 where col2 not in ....another
select statement that returns a list of values for col2

Thanks
Daud11

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

[Thomas Kyte]

A copy of this was sent to dau...@hotmail.com
(if that email address didn't require changing)

On Sat, 03 Jul 1999 08:42:52 GMT, you wrote:

>Hi
>
>I would to know if it is possible to a sub-select statement in the
>select statement of POPULATE_GROUP_WITH_QUERY.
>

Yes

>This is the code I am trying to write but not sure how.
>
>status := POPULATE_GROUP_WITH_QUERY('LISTDEL_REC',
> 'select col1, col2 from table1 where col2 not in ....another
>select statement that returns a list of values for col2
>

'select col1, col2 from table1 where col2 not in ( select X from T )'

Although, you might find:

'select col1, col2 from table1 where NOT EXISTS ( select null from T where x =
table1.col2 )'

to be faster.

>Thanks
>Daud11
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte tk...@us.oracle.com
Oracle Service Industries Reston, VA USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation