Note: If you have the values inside the data file enclosed with double quote, use this in your control file: fields terminated by “,” optionally enclosed by ‘”‘ Next create the control file that explains what needs to be upload and where. ( id, name, dept, salary ) – Lists the name of the column names in the table into which the data should be uploadedįirst, create the employee table as shown below.fields terminated by – Indicates the delimiter that is used in the input file to separate the fields.into table – Indicates the table name where this data should be inserted.infile – Indicates the location of the input data file.The above control file indicates the following: This tells sqlldr the location of the input file, the format of the input file, and other optional meta data information required by the sqlldr to upload the data into oracle tables. This contains the instructions to the sqlldr utility. $ cat employee.txtĥ01,Ritu,Accounting,5400 SQL*Loader Control File For some of the examples mentioned below, we’ll use the following employee.txt file to upload the data to the employee table. Each and every records needs to be in a separate line, and the column values should be delimited by some common delimiter character. This is the input text file that contains the data that needs to be loaded into an oracle table. This article provides 10 practical examples on how to upload data from a flat file to Oracle tables. If you are using Oracle database, at some point you might have to deal with uploading data to the tables from a text file.
0 kommentar(er)
