Thanks Adi Cohn,

You are given solution that is really helpful to me.

Thanks

Thanks for your reply.

Sorry, One small correction. File Name is " Vendor_ABC_Pro_20210422T205535_Region_20210422_20210422.json".

In this file, we have this datetime 20210422T205535. I need 205535 (hhmmss) from this format 20210422T205535 after T. Can...

Thanks. Its working fine now.

Hi,

Thanks for your reply. I am using PIVOT table concept already. I am using Oracle 10g. 10g version is not supported PIVOT Table.

Thats why i think that using sql query...

Hi,

Thanks for your reply. I am using PIVOT table concept already. I am using Oracle 10g. 10g version is not supported PIVOT Table.

Thats why i think that using sql query...