Master your Minecraft

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Tour our stores

    Recently Viewed clear list

    The Powell's Playlist | October 21, 2014

    Anne Rice: IMG The Powell’s Playlist: Anne Rice

    These are the songs that wake me up, take me out of my worries and anxieties, wash my brain cells, and send me to the keyboard to write with new... Continue »

Qualifying orders ship free.
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Database- Design

Oracle SQL Loader: The Definitive Guide


Oracle SQL Loader: The Definitive Guide Cover


Synopses & Reviews

Publisher Comments:

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.


A step-by-step guide of all the tasks that Oracle developers and DBAs need to perform with SQL*Loader. Readable and informative, this reference is a task-oriented learning tool for those already using this utility.

About the Author

Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQLLoader (O'Reilly & Associates, 2001); Oracle SQLPlus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at, and you can learn more about him personally by visiting his website at

Sanjay Mishra is a certified Oracle database administrator with more than ten years of IT experience. He has been involved in the design, architecture, and implementation of many mission-critical and decision support databases. He has worked extensively in the areas of database architecture, database management, backup / recovery, performance tuning, Oracle Parallel Server, and parallel execution. He has a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the coauthor of Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly & Associates). Presently, he works as a database architect at Dallas Based i2 Technologies, and can be reached at

Table of Contents

CopyrightDedicationPrefaceChapter 1: Introduction to SQL*LoaderChapter 2: The Mysterious Control FileChapter 3: Fields and DatatypesChapter 4: Loading from Fixed-Width FilesChapter 5: Loading Delimited DataChapter 6: Recovering from FailureChapter 7: Validating and Selectively Loading DataChapter 8: Transforming Data During a LoadChapter 9: Transaction Size and Performance IssuesChapter 10: Direct Path LoadsChapter 11: Loading Large ObjectsChapter 12: Loading Objects and CollectionsColophon

Product Details

The Definitive Guide
Gennick, Jonathan
Mishra, Sanjay
O'Reilly Media
Sebastopol, CA
Programming Languages - SQL
Database Management - General
Database management
Relational databases
Sql (computer program language)
Database Management - Oracle
Database design
CourseSmart Subject Description
Edition Description:
Print PDF
Series Volume:
no. 47
Publication Date:
9.16x7.04x.74 in. .96 lbs.

Other books you might like

  1. Practical Oracle8i(TM): Building... New Trade Paper $56.95
  2. Database Systems in Science and... New Hardcover $221.75
  3. Component Database Systems (Morgan... New Hardcover $106.25
  4. Oracle 9i Java Programming:... Used Trade Paper $3.95
  5. Oracle9ias Building J2ee(tm)... New Trade Paper $73.50
  6. Oracle Xsql New Trade Paper $81.77

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Networking » General
Computers and Internet » Software Engineering » Software Management
History and Social Science » World History » General

Oracle SQL Loader: The Definitive Guide New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 274 pages O'Reilly & Associates - English 9781565929487 Reviews:
"Synopsis" by ,
A step-by-step guide of all the tasks that Oracle developers and DBAs need to perform with SQL*Loader. Readable and informative, this reference is a task-oriented learning tool for those already using this utility.
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at