If those are text files you can create the table with single column and then process them line by line
On Thu, Sep 4, 2014 at 6:13 PM, CHEBARO Abdallah <abdallah.cheb...@murex.com > wrote: > Hello, > > > > Is it possible to create an external table without specifying the columns? > > > > In fact, I am creating an external table that points to a directory that > contains 3 text file, and each text file has different number of columns. > > > > Thanks > > ******************************* > > This e-mail contains information for the intended recipient only. It may > contain proprietary material or confidential information. If you are not > the intended recipient you are not authorised to distribute, copy or use > this e-mail or any attachment to it. Murex cannot guarantee that it is > virus free and accepts no responsibility for any loss or damage arising > from its use. If you have received this e-mail in error please notify > immediately the sender and delete the original email received, any > attachments and all copies from your system. > -- Nitin Pawar
