AboutPeter Choi Expertise I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with
10+ years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and
8.9), Oracle RDBMS (7.3 - 11gR1) on various Unix and Windows platforms, and some Oracle Application Server (9i/10gR2). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x.
Question Hello Sir,
I want a help in creating dynamic table as per the csv file. The csv file which is to be uploaded does not have a fixed format (No. of columns). So I want to create table with the same number of column as present in the csv file.
Thanks,
Rocky
Answer Hi Rocky,
There isn't an easy way to create a table based on a dynamic data set (i.e. varying columns and format). You may want to consider loading the data from your CSV files as straight text, and use Oracle's Regular Expressions (http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/rischert_re...) to dynamic parse and create as required views or tables that you need for your application to work.
