Oracle SQL*Loader the definitive guide
SQLLoader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQLLoader is to load data from flat files into an Oracle database. It&#...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing :
O'Reilly
2001.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626915506719 |
Tabla de Contenidos:
- Table of Contents; Preface; Why We Wrote This Book; Audience for This Book; Platform and Version; Structure of This Book; Conventions Used in This Book; Comments and Questions; Acknowledgments; From Jonathan; From Sanjay; Introduction to SQL*Loader; The SQL*Loader Environment; The SQL*Loader Control File; The Log File; The Bad File and the Discard File; A Short SQL*Loader Example; The Data; The Control File; The Command Line; The Log File; SQL*Loader's Capabilities; Issues when Loading Data; Recovery from Failure; Transaction Size; Data Validation; Data Transformation; Invoking SQL*Loader
- Command-Line ParametersCommand-Line Syntax Rules; Parameter Precedence; The Mysterious Control File; Syntax Rules; Free Format; Case Sensitivity; Table and column names; Filenames; Comments; Special Characters; Table and column names; Filenames; The escape character; Reserved Words; The LOAD Statement; LOAD DATA Syntax; Specifying Input Files; Loading from one input file; Loading from multiple input files; Specifying the table loading method; Specifying the Target Tables; Loading one table; Loading delimited data into multiple tables; Loading fixed-width data into multiple tables
- Loading a table partitionCommand-Line Parameters in the Control File; Placing Data in the Control File; Fields and Datatypes; Field Specifications; Scalar Fields; Understanding Field Positions; Specifying the starting position of a field; Specifying the ending position of a field; Advantages of relative positioning; Filler Fields; Using filler fields to skip data; Other uses for filler fields; Generated Fields; Datatypes; Portable Datatypes; CHAR; DATE; INTEGER, FLOAT, DECIMAL, and ZONED EXTERNAL; GRAPHIC; GRAPHIC EXTERNAL; RAW; VARCHARC; VARRAWC; Nonportable Datatypes
- INTEGER, SMALLINT, FLOAT, DOUBLE, and BYTEINTZONED; DECIMAL; VARGRAPHIC; VARCHAR; VARRAW; LONG VARRAW; Loading from Fixed-Width Files; Common Datatypes Encountered; Specifying Field Positions; Starting and Ending Position; Starting Position and Length; Field Type and Length; Handling Anomalous Data; Trimming Whitespace; The PRESERVE BLANKS clause; Selective trimming of whitespace; Dealing with Nulls; SQL*Loader's default behavior; The effect of PRESERVE BLANKS; NULLIF; DEFAULTIF; Dealing with "Short" Records; Database Column Defaults; Concatenating Records; CONCATENATE; CONCATENATE syntax
- CONCATENATE exampleCONTINUEIF; CONTINUEIF syntax; CONTINUEIF THIS; CONTINUEIF NEXT; Using not-equals; Nesting Delimited Fields; Extracting Subfields; Separating the latitude and longitude; Separating the individual latitude and longitude components; Variable-Length Records; Loading Delimited Data; Common Datatypes Encountered; Example Data; Using Delimiters to Identify Fields; Specifying Termination Characters; Syntax for TERMINATED BY; Example: Field-specific delimiters; Example: One delimiter for all fields; Example: Multi-character delimiters; Specifying Enclosing Characters
- Syntax for ENCLOSED BY
