How to create table Dynamically and drop the table after the output
Dear gurus,
We have a requirement to get details of inventory items with a long processing for each and every inventory items.
Right now we have an inventory items of more than 1 lakh line items and the report requirement is to get the data of onhand quantiites, MAD,franchise,etc details.
I made a query to get the details and i am able to get the data, but when i am exporting the data into excel. it is hanging my toad session.
Now My actual requirement . User wants this report to be registered as a concurrent program and he will run this report whenever he wants.output type is EXCEL.
0