Search Results

Thanks.its working great.

I just want to extract text between ${} along with file name.
as below

abc.sql STG_RET_ITEM STG_INC_COMP
abc.sql STG_LOC_REG


Use code tags as being asked for thanks. Got a PM with a guide...

I got multple sql files.such as
>>vi abc.sql
select A.SITENAME,
NULL
NULL
A.CREATE_DTM
NULL
A.MODIFY_DTM
NULL
FROM ${STG_RET_ITEM} A INNER JOIN ${STG_INC_COMP} B ON (A.CUSTID=B.CUSTID)
LEFT...