Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create table dynamically using stored procedure

Albert ChaoOct 26 2021

Hi,
I have a query regarding creating tables dynamically using stored procedures and then inserting data into that table. Data will be present in an excel file with the required columns. From the excel I need to create one table and load the data into that table. Can we do this using stored procedure or is this feasible ? I have the attached excel file.
test_file.xlsx (8.63 KB)

Comments
Post Details
Added on Oct 26 2021
16 comments
1,512 views