require to extract only the table names from an expression
851505Jun 13 2011 — edited Jun 13 2011hi all...:)
hope everyone had a lovely weekend!
ok. getting back to monday... here is my problem question :
I have a string say STRING A like this :
" DRI_998_HDR_BPMS_ACTIVITY.PROC_CODE = DRI_998_HDR_BPMS_PROCESS.PROC_CODE,
DRI_998_HDR_BPMS_PROCESS.PROC_CODE = DRI_998_HDR_WORKFLOW.BPMS_PROC_CODE,
DRI_998_HDR_WORKFLOW.EVN_UNIT_CODE = DRI_998_HDR_EVENT_PRODUCT_UNIT.EVN_UNIT_CODE,
DRI_998_HDR_EVENT_PRODUCT_UNIT.PROD_UNIT_CODE = DRI_998_HDR_PRODUCT_UNIT.PROD_UNIT_CODE "
it basically gives me the join conditions of several tables.
what i require is this STRING B :
" FROM DRI_998_HDR_BPMS_ACTIVITY, DRI_998_HDR_BPMS_PROCESS , DRI_998_HDR_WORKFLOW , DRI_998_HDR_EVENT_PRODUCT_UNIT , DRI_998_HDR_PRODUCT_UNIT "
so i need to get all the table names ( STRING B) from that join condition string (STRING A)
Please suggest how i may do so cause i am stuck..
Thanks in advance to all those wit brains out there!
have a great work week!