Hi,
How to use 'Execute Immediate' command for below query. I am working on oracle.
SELECT T1.PROD_LINE_CD,T1.BUS_GROUP_CD,T1.BUS_UNIT_CD,T1.COUNTRY_CD
FROM Table1 T1,Table2 T2
WHERE T1.AUTH_PROFILE_CD=T2.AUTH_PROFILE_CD
AND T2.ACTIVE_FL='Y';
AND T1.PROD_LINE_CD = :v_PROD_LINE_CD
AND T1.BUS_GROUP_CD= :v_BUS_GROUP_CD
AND T1.BUS_UNIT_CD=:v_BUS_UNIT_CD
AND T1.COUNTRY_CD=:v_COUNTRY_CD
Thanks in advance.
...
Go to the complete details ...