It is difficult to understand your requirement. Could you give some example
data from both tables and an example of what you would like the result
(output) to look like.
Mike
On Tue, Sep 9, 2008 at 8:05 AM, Oracle Deen <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> Thanks to everyone. It i working as expected.
>
> Further our requirement is extended as the card_details query should be
> matched with all location_id provided comma separated string.
>
> The issue is the below query is working even any one of location ifd found
> in the card_details table where as it should match all the location id in
> the local variable. In the child query i need to use = ALL keyword where i
> am missing up.
>
>
> Ex:
>
> localvar_card_location_id = '1,4,5,6';
>
> sql_dy_query := 'SELECT card_id, card_name, card_type FROM card_header ch '
>
> || ' WHERE (card_type = ''N'' OR
> || ' EXISTS (SELECT 1 FROM card_details cd WHERE ch.card_id
> = cd.card_id AND cd.card_status = ''A''
> || ' AND card_location_id IN ('||
> localvar_card_location_id||' )) '
> || ' ) AND SYSDATE BETWEEN ch.valid_start_date AND
> ch.valid_end_date;
>
>
> Thanks in Advance
>
> Deen
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
