Stack Overflow
Stack Overflow

Questions tagged [sql-loader]

SQL*Loader is a high-speed data loading utility that loads data from external files into tables in an Oracle database.

SQL*Loader is a high-speed data loading utility that loads data from external files into tables in an Oracle database. SQL*Loader accepts input data in a variety of formats, can perform filtering, and can load data into multiple Oracle database tables during the same load session.

Source: http://www.oracle.com/technetwork/database/enterprise-edition/index-093639.html

1010 questions
0
votes
1 answer

How to load delimited file (multiple delimiters) into Oracle?

I have a file that has information that is primarily pipe delimited. But some fields are further delimited within. I guess you can call them nested delimited? This is how the rows in my file…
Joshua1729
  • 775
  • 4
  • 10
  • 19
0
votes
1 answer

Can I add SQL statements in Oracle Loader file

I suppose to write Oracle Loader file to insert/append the data from csv file. Now I have a requirement where I have to change column filed of ecery existing record before doing the insert/append. Is it possible to add some PL/SQL statement in the…
CrazyC
  • 1,840
  • 6
  • 39
  • 60
0
votes
1 answer

Oracle: What is the difference between array binding and sql loader?

I was using bcp (sybase mass insert) to insert millions of records but my company is migrating to oracle. I am not sure if I should use array binding or sql loader. I have a lot of data in memory. I can either 1. Create a text file with the data…
anthonybell
  • 5,790
  • 7
  • 42
  • 60
0
votes
1 answer

How to use select statements in control file in oracle

I want to add the following statement in control file(sql load file). select 123456, regexp_replace(123456, '(\d+)(\d{2})', '\1.\2') from table_1; Please advice.
user2647888
  • 721
  • 1
  • 13
  • 22
0
votes
2 answers

SQLLoader without ControlFile

Is there any way I can run SQLLoader and put in the command line all the options I would normally write in the control file? The reason I ask is, I need to load different .csv in different tables at different times, and It would be much easier if I…
gcaglion
  • 131
  • 1
  • 12
0
votes
1 answer

Set a specific cell value to a column (CTL)

I have created a CTL file that will read the data inside a CSV file. It loads the data from the CSV to the table in the database. I just want to ask if it is possible to set a table column to a specific cell on CSV file when loading data using…
user3462803
  • 170
  • 1
  • 2
  • 10
0
votes
1 answer

oracle sqlloader new line at the end of the file

have a file that is in format x,y which should be loaded using sql loader x y a bnew line All data is loaded to table A(x,y) where x,y are varchar2 - this step passes successfully. Next step is processing loaded data - i.e. transforming data to…
Saulius S
  • 391
  • 2
  • 4
  • 12
0
votes
1 answer

Insert unstructured records into database

I have a flat file with about half a million records in this format: last_login=2014022 BPN=1234567890 first_last_names=portal…
user996853
  • 41
  • 7
0
votes
0 answers

Column Values shifting to next row while creating a CSV using SQL *Plus

I want the output of a SQL query in a csv file. While other such jobs are running successfully, here is a job, one of them, which gives me a csv like this. I have checked the loader control file - it seems fine. I have also checked the SQL query -…
MontyPython
  • 2,906
  • 11
  • 37
  • 58
0
votes
2 answers

Will a bulk loader preserve order of rows while inserting

If I use an sql bulk loader to load 10 000 rows into an oracle database from a flat file, will the rows be inserted in the same order as they appear in the file? For example, let us say there is a unique key column that is automatically incremented…
Victor
  • 16,609
  • 71
  • 229
  • 409
0
votes
0 answers

ÿ is not displaying while concatenate with other column in oracle

I have a problem regarding a special character. I have a table test as below: SQL> desc test Name Type Nullable Default Comments -------------- ----------------- -------- ------- -------- DOT DATE Y …
user3726320
  • 44
  • 6
0
votes
2 answers

Sql*loader How to check for range

I want to put a range check in my control file, but I don't see any construct to do so. Using DEFAULTIF DEFAULTIF my_col not between 0 and 1 sets the value of my_col to 0. as its defined as number(12,8) Is there a way to set it to say -1 if the…
Manoj
  • 5,542
  • 9
  • 54
  • 80
0
votes
2 answers

How to replace a comma (',') with a period ('.') while loading using sql loader

I have number(20,4) field for which the data is coming in the following format : 120,24 200,45 I want to insert it into a table in the following format : 120.24 200.45 Below is the control file : LOAD DATA TRUNCATE INTO TABLE…
Mariners
  • 499
  • 8
  • 18
0
votes
1 answer

SQLLDR : merger year,mon and day

I have csv file that contains shown below : year,mon,day 2014,12,01 2013,10,30 and abc's table create table abc ( year varchar2(4), mon varchar2(2), day varchar2(2), date1 date ) how to tell loader.ctl to merger year,mon,day become date? like that…
flyingbird013
  • 446
  • 2
  • 12
  • 28
0
votes
1 answer

SQL*Loader : data loading with treatments

i want to load some data with SQL*Loader by the following steps: -load some columns of data in the text file. -make transformations into some data during loading. my file lines format is a sequence of like this: 123 G 100 data 122 EGG .... 123 G…
Med
  • 35
  • 1
  • 6
1 2 3
…
67 68