Load White Space Delimited Data

How to load whitespace delimited data using SQL*Loader?

Showing Answers 1 - 3 of 3 Answers

psingla
Profile Answers by psingla Questions by psingla

Apr 21st, 2010

1. Create a ontrol file with extn (.ctrl). This file will map the flat file data with the Oracle table columns.
2. Pass control file as one of the parameter of SQL Loader.

How to convert single row to two columns
Sort v/s sort within groups
Incremental loading flat file data capture
Load a file in Oracle in chunks of 100 MB files
Not able to store the data in my database
Floor casting
Pipeline, component and data parallelism
Load different data files in single target table
Show the output of a query plan to user
Dynamic target creation using source data

Fetch next record data
3 phase
Highest input data transfer rate
Payment terms
Rdbms
Testing tools for django project
Rank transformation type and range by partition
Uft14 open and copy data from XML
Concatenate two circularly single linked list into one circularly linked list
Datacopy

It looks like you are using an AD Blocker!

Please Turn OFF your ad blocker

- OR -

Disable
Ad Blocker

Learn More

Create your
GeekInterview account

Signup

Continue Reading after Disabling

Refresh

Load White Space Delimited Data

psingla
Profile Answers by psingla Questions by psingla

Give your answer:

Related Answered Questions

Related Open Questions

Latest News

It looks like you are using an AD Blocker!

Login

Load White Space Delimited Data

psingla Profile Answers by psingla Questions by psingla

Give your answer:

Related Answered Questions

Related Open Questions

Latest News

It looks like you are using an AD Blocker!

psingla
Profile Answers by psingla Questions by psingla