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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
