Verwandte Artikel zu Oracle SQL Loader: The Definitive Guide
Inhaltsangabe
SQL*Loader 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 SQL*Loader 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 SQL*Loader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQL*Loader's wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQL*Loader: The Definitive Guide has everything you need to know to put SQL*Loader to its best use: an introduction to SQL*Loader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQL*Loader 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 SQL*Loader performance by adjusting the transaction size and using the new direct path option. It also covers the newest SQL*Loader features--the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables). Oracle SQL*Loader: The Definitive Guide is an indispensable resource for anyone who is new to SQL*Loader; 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.
Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.
Über die Autorin bzw. den Autor
Jonathan Gennick is a writer and editor. His writing career began in 1997 when he coauthored Teach Yourself PL/SQL in 21 Days. Since then, he has written several O'Reilly books, including Oracle SQL*Plus: The Definitive Guide, Oracle SQL*Plus Pocket Reference, and Oracle Net8 Configuration and Troubleshooting. He has also edited a number of books for O'Reilly and other publishers, and he recently joined O'Reilly as an associate editor, specializing in Oracle books. Jonathan was formerly a manager in KPMG's Public Services Systems Integration practice, where he was also the lead database administrator for the utilities group working out of KPMG's Detroit office. He has more than a decade of experience with relational databases. Jonathan is a member of MENSA, and he holds a bachelor of arts degree in information and computer science from Andrews University in Berrien Springs, Michigan. He currently resides in Munising, Michigan, with his wife Donna and their two children: twelve- year-old Jenny, who often wishes her father wouldn't spend quite so much time writing, and five-year-old Jeff, who has never seen it any other way. Sanjay Mishra is a certified Oracle database administrator with more than nine years of IT experience. For the past six years, 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, disaster planning, performance tuning, Oracle Parallel Server, and parallel execution. he has a bachelor of science degree in electrical engineering and a master of engineering in systems science and automation. He is the coauthor of Oracle Parallel Processing (O'Reilly & Associates, 2000) and can be reached at sanjay_mishra@i2.com.
„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.
Neu kaufen
Diesen Artikel anzeigen
EUR 35,98
Gratis für den Versand innerhalb von/der Deutschland
Versandziele, Kosten & DauerSuchergebnisse für Oracle SQL Loader: The Definitive Guide
Beispielbild für diese ISBN
Oracle Sql*loader: The Definitive Guide
Anbieter: ThriftBooks-Dallas, Dallas, TX, USA
Verkäuferbewertung 5 von 5 Sternen
Paperback. Zustand: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 0.97. Artikel-Nr. G1565929489I3N00
Anzahl: 1 verfügbar
Beispielbild für diese ISBN
Oracle Sql*loader: The Definitive Guide
Anbieter: ThriftBooks-Dallas, Dallas, TX, USA
Verkäuferbewertung 5 von 5 Sternen
Paperback. Zustand: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 0.97. Artikel-Nr. G1565929489I4N00
Anzahl: 1 verfügbar
Beispielbild für diese ISBN
Oracle SQL*Loader: the Definitive Guide
Verlag:
O'Reilly Media, Incorporated, 2001
ISBN 10: 1565929489
ISBN 13: 9781565929487
Gebraucht
Softcover
Erstausgabe
Anbieter: Better World Books, Mishawaka, IN, USA
Verkäuferbewertung 5 von 5 Sternen
Zustand: Good. 1st Edition. Used book that is in clean, average condition without any missing pages. Artikel-Nr. 1442271-6
Anzahl: 2 verfügbar
Beispielbild für diese ISBN
Oracle Sql*loader: The Definitive Guide
Anbieter: WorldofBooks, Goring-By-Sea, WS, Vereinigtes Königreich
Verkäuferbewertung 5 von 5 Sternen
Paperback. Zustand: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Artikel-Nr. GOR003043837
Anzahl: 1 verfügbar
Beispielbild für diese ISBN
Oracle SQL*Loader: The Definitive Guide
Anbieter: Wonder Book, Frederick, MD, USA
Verkäuferbewertung 5 von 5 Sternen
Zustand: As New. Like New condition. A near perfect copy that may have very minor cosmetic defects. Artikel-Nr. A10A-02551
Anzahl: 1 verfügbar
Foto des Verkäufers
Oracle Sql*loader: The Definitive Guide: The Definitive Guide
Anbieter: moluna, Greven, Deutschland
Verkäuferbewertung 5 von 5 Sternen
Zustand: New. This text describes all of SQL*Loader s functions, including how to construct the necessary control files, load different types of data, and get the best performance. It covers the newest SQL*Loader features for 2001. SQL Loader is a ubiquitous tool in. Artikel-Nr. 596324873
Anzahl: Mehr als 20 verfügbar
Foto des Verkäufers
Oracle Sql*loader: The Definitive Guide
Anbieter: AHA-BUCH GmbH, Einbeck, Deutschland
Verkäuferbewertung 5 von 5 Sternen
Taschenbuch. Zustand: Neu. Neuware - 'SQL Loader' 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 'SQL Loader' 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 'SQL Loader' at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite 'SQL Loader's' wide availability and usage, few DBAs and developers know how to get the most out of it. 'Oracle SQL Loader': This Guide has everything you need to know to put 'SQL Loader' to its best use: an introduction to 'SQL Loader', a reference to all of its syntax options, and most importantly, step-by-step instructions for all the 'SQL Loader' 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 'SQL Loader' performance by adjusting the transaction size and using the new direct path option. It also covers the newest 'SQL Loader' features - the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables).'Oracle SQL Loader': The Definitive Guide is an indispensable resource for anyone who is new to 'SQL Loader'; 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. Artikel-Nr. 9781565929487
Anzahl: 2 verfügbar
Beispielbild für diese ISBN
Oracle SQL*Loader: The Definitive Guide
Anbieter: Ria Christie Collections, Uxbridge, Vereinigtes Königreich
Verkäuferbewertung 5 von 5 Sternen
Zustand: New. In. Artikel-Nr. ria9781565929487_new
Anzahl: 2 verfügbar
Beispielbild für diese ISBN
Oracle Sql*Loader: The Definitive Guide
Anbieter: Revaluation Books, Exeter, Vereinigtes Königreich
Verkäuferbewertung 5 von 5 Sternen
Paperback. Zustand: Brand New. 272 pages. 9.00x6.75x0.75 inches. In Stock. Artikel-Nr. x-1565929489
Anzahl: 2 verfügbar