FratFiles

• Save Paper

Document K2.6
Using SQL*Loader
Document K2.6
Using SQL*Loader
1 Introduction
1 Running SQL*Loader
2 Control file
2 Examples
2 Loading from a separate data file using fixed format data
3 Loading from data in the control file using free format data
4 Selecting data
4 Reading multiple rows per record
5 References
Introduction
The SQL*Loader module of the ORACLE Database Management
System loads data into an existing ORACLE table from an external file.
It is available locally only on CMS and PCs with ORACLE version 5.
Throughout this document the CAR database described in Reference A is
used for illustration.
There are several methods other than using SQL*Loader of inserting data
into a table:
¤ The SQL insert command may be used from the SQL*Plus module
(see Reference B), for example:
insert into CAR values ( . . . )
where the values to be inserted into a row of the table are listed
inside the parentheses. Dates and character data must be surrounded
by single......

View the rest of this paper...

Approximate Word Count: 1456
Approximate Pages: 6 (250 words per double-spaced page)

Similar Essays

1. Character Analysis Of Mr. Beelzy In John Collier'S
   

   Character Analysis of Mr. Beelzy in John Collier's. ... In John Collier's short story,
   "Thus I Refute Beelzy," Mr. Beelzy is one such character. ...

2. Dr Jekyll And Mr Hyde(Evil Won Or Good Won?)
   

   DR Jekyll and MR Hyde(Evil Won or good won?). Throughout the history ... the world.
   These two characters were Dr. Jekyll and Mr. Hyde. Dr ...

3. Dr. Jekyll And Mr. Hyde
   

   Dr. Jekyll and Mr. Hyde. 1. Analytical Method ... heir. At first Mr. Utterson discussed
   Dr. Jekyll's character with Mr. Enfield. Mr. Enfield ...

4. Dr. Jekyl And Mr. Hyde
   

   Dr. Jekyl and Mr. Hyde. Robert Louis Stevenson in "Dr. Jekyll and Mr. Hyde" is telling
   people that they fear the knowledge of their duality so they keep silent. ...

5. Dr. Jekyle And Mr. Hyde - Book Report
   

   Dr. Jekyle And Mr. Hyde - Book Report. 1. Name of Book? The name of the
   Book is Dr. Jekyll and Mr. Hyde. 2. Author of Book? The ...