eBook
Προβολή σε EDS

Oracle SQL*Loader: The Definitive Guide : The Definitive Guide

Λεπτομέρειες βιβλιογραφικής εγγραφής
Τίτλος: Oracle SQL*Loader: The Definitive Guide : 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's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format.Almost every Oracle user has to use SQLLoader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQLLoader's wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQLLoader: The Definitive Guide has everything you need to know to put SQLLoader to its best use: an introduction to SQLLoader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQLLoader tasks you'd want to perform--and maybe some you didn't realize you COULD perform.You'll learn how to construct the necessary control files and load from different types of files containing different types of data (e.g., fixed-width data, delimited data, and data of various datatypes). You'll also learn how to validate data, load it selectively, transform it as it is loaded, and recover after failure. This book explains how to optimize SQLLoader performance by adjusting the transaction size and using the new direct path option. It also covers the newest SQLLoader features--the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables).Oracle SQLLoader: The Definitive Guide is an indispensable resource for anyone who is new to SQLLoader; a task-oriented learning tool for those who are already using it; and a quick reference for every user. If you want to take best advantage of an essential Oracle tool, you need this book.
Συγγραφείς: Jonathan Gennick, Sanjay Mishra
Resource Type: eBook.
Θέματα: Relational databases, SQL (Computer program language), Programming languages (Electronic computers)
Categories: COMPUTERS / Database Administration & Management
Βάση Δεδομένων: eBook Index
FullText Text:
  Availability: 0
Header DbId: edsebk
DbLabel: eBook Index
An: 415281
RelevancyScore: 831
AccessLevel: 6
PubType: eBook
PubTypeId: ebook
PreciseRelevancyScore: 830.635864257813
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Oracle SQL*Loader: The Definitive Guide : The Definitive Guide
– Name: Abstract
  Label: Description
  Group: Ab
  Data: 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's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format.Almost every Oracle user has to use SQLLoader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQLLoader's wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQLLoader: The Definitive Guide has everything you need to know to put SQLLoader to its best use: an introduction to SQLLoader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQLLoader tasks you'd want to perform--and maybe some you didn't realize you COULD perform.You'll learn how to construct the necessary control files and load from different types of files containing different types of data (e.g., fixed-width data, delimited data, and data of various datatypes). You'll also learn how to validate data, load it selectively, transform it as it is loaded, and recover after failure. This book explains how to optimize SQLLoader performance by adjusting the transaction size and using the new direct path option. It also covers the newest SQLLoader features--the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables).Oracle SQLLoader: The Definitive Guide is an indispensable resource for anyone who is new to SQLLoader; a task-oriented learning tool for those who are already using it; and a quick reference for every user. If you want to take best advantage of an essential Oracle tool, you need this book.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Jonathan+Gennick%22">Jonathan Gennick</searchLink><br /><searchLink fieldCode="AR" term="%22Sanjay+Mishra%22">Sanjay Mishra</searchLink>
– Name: TypePub
  Label: Resource Type
  Group: TypPub
  Data: eBook.
– Name: Subject
  Label: Subjects
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Relational+databases%22">Relational databases</searchLink><br /><searchLink fieldCode="DE" term="%22SQL+%28Computer+program+language%29%22">SQL (Computer program language)</searchLink><br /><searchLink fieldCode="DE" term="%22Programming+languages+%28Electronic+computers%29%22">Programming languages (Electronic computers)</searchLink>
– Name: SubjectBISAC
  Label: Categories
  Group: Su
  Data: <searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Database+Administration+%26+Management%22">COMPUTERS / Database Administration & Management</searchLink>
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=415281
RecordInfo BibRecord:
  BibEntity:
    Classifications:
      – Code: 005.7585
        Scheme: ddc
        Type: prePub
    Languages:
      – Code: eng
        Text: English
    Subjects:
      – SubjectFull: Relational databases
        Type: general
      – SubjectFull: SQL (Computer program language)
        Type: general
      – SubjectFull: Programming languages (Electronic computers)
        Type: general
    Titles:
      – TitleFull: Oracle SQL*Loader: The Definitive Guide : The Definitive Guide
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Jonathan Gennick
      – PersonEntity:
          Name:
            NameFull: Sanjay Mishra
      – PersonEntity:
          Name:
            NameFull: Jonathan Gennick
      – PersonEntity:
          Name:
            NameFull: Sanjay Mishra
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 01
              Type: published
              Y: 2001
            – D: 04
              M: 02
              Type: profile
              Y: 2014
          Identifiers:
            – Type: isbn-print
              Value: 9781565929487
            – Type: isbn-electronic
              Value: 9780596520373
          Titles:
            – TitleFull: Oracle SQL*Loader: The Definitive Guide : The Definitive Guide
              Type: main
ResultId 1