Hi All,
I would like to know the format file equivalent of SQL Server in Oracle. I see there is something called Control File in Oracle but to load data from a text file to my Oracle database table. However, I would like to load only few columns from the text file to my database.
The delimiter in my text file for each column would be either '|' or ',' and one or two columns of the text file I'm trying to load may contain other characters like ' " ' (double quotes), ':' etc.
Could someone please help me with this?
Thank you,
Julaayi