Search Results

Thanks Devaraj for your reply

Here i stuck up with one more issue, see below file contents there are alias for column names too
select col1, col2 from schema_Name.Table_Name1 a
select * from...

thanks Devaraj

Could you help me out to pull Table_Name alone without alias name

select col1, col2 from schema_Name.Table_Name1 a
select * from schema_Name.Table_Name2 b
select col1, col2,...

I have a txt file with below data (textfile1.txt)

select col1, col2 from Schema_Name.Table_Name1
select * from Schema_Name.Table_Name2
select col1, col2, col3 from Schema_Name.Table_Name3...