Share
eBooks from Jonathan Gennick
All books and eBooks by Jonathan Gennick:
Oracle SQL*Plus: The Def...
The Definitive Guide
Chapter 1 CHAPTER 1 Introduction to SQL*Plus SQL*Plus is the command-line interface to the Oracle database. It exists to let you enter and execute ad hoc SQL statements and PL/SQL code blocks, and, if you’re a database administrator (DBA), to issue database administration commands such as STARTUP and SHUTDOWN. This chapter explains what SQL*Plus is, how it relates to the Oracle database, and why you should master it. At the end of the chapter, I’ll introduce you to the sample data used for many of the examples in this book. You can load the data and follow along as you read. What Is SQL*Plus? SQL*Plus is essentially an interactive query tool with some scripting capabilities. You can enter a SQL statement, such as a SELECT query, and view the results. You can execute data definition language (DDL) statements to create tables and other objects. DBAs can use SQL*Plus to start
(2007)
Transact-SQL Cookbook
by Ales Spetic and Jonathan Gen...
Chapter 1 CHAPTER 1 Pivot Tables 1.1 Using a Pivot Table Problem Support for a sequence of elements is often needed to solve various SQL problems. For example, given a range of dates, you may wish to generate one row for each date in the range. Or, you may wish to translate a series of values returned in separate rows into a series of values in separate columns of the same row. To implement such functionality, you can use a permanent table that stores a series of sequential num- bers. Such a table is referred to as a Pivot table. Many of the recipes in our book use a Pivot table, and, in all cases, the table’s name is Pivot. This recipe shows you how to create that table. Solution First, create the Pivot table. Next, create a table named Foo that will help you popu- late the Pivot table:
(2007)
Oracle Regular Expressio...
by Jonathan Gen... and Peter Linsley
Oracle Regular Expressions Pocket Reference Introduction With the release of Oracle Database 10g, Oracle has intro- duced regular expression support to the company’s flagship product. Regular expressions are used to describe patterns in text, and they are an invaluable aid when working with loosely formatted textual data. This little booklet describes Oracle’s regular expression sup- port in detail. Its goal is to enable you to take full advantage of the newly introduced regular expression features when querying and manipulating textual data. Organization of This Book This book is divided into the following six sections: Introduction You’re reading it now. Tutorial Provides a short regular expression tutorial aimed at those who aren’t already familiar with regular expressions. Oracle’s Regular Expression Support For readers familiar with regular expressions, describes how they are implemented and used within Oracle. Also includes a description of the key differences between the regular expression implementations of Perl
(2003)
SQL Pocket Guide
Organization of This Book After this introduction, topics are organized alphabetically, with section names carefully chosen to correspond to rele- vant SQL keywords. If you need help writing a join, for example, you should be able to quickly flip through the book and find the section titled “Joining Tables” between the sec- tions “Inserting Data” and “Literals.” Consult the table of contents and/or the index if you don’t immediately find what you’re looking for. Feedback Needed! Many thanks to all of the readers of the first edition who took the time to provide feedback and suggestions. As the result of an overwhelming number of requests, I’ve added coverage of CREATE TABLE statements and datatypes to this edition. I’ve also included a discussion of the powerful and increasingly significant PostgreSQL platform, as well as coverage of the very potent window functions (which are sometimes called analytic functions). I hope there will
(2008)
Oracle SQL*Loader: The D...
The Definitive Guide
by Jonathan Gen... and Sanjay Mishra
Chapter 1 1 In this chapter: • The SQL*Loader Environment • A Short SQL*Loader Example • SQL*Loader’s Capabilities • Issues when Loading Data • Invoking SQL*Loader Introduction to SQL*Loader SQL*Loader is an Oracle-supplied utility that allows you to load data from a flat file into one or more database tables. That’s it. That’s the sole reason for SQL*Loader’s existence. The basis for almost everything you do with SQL*Loader is a file known as the control file. The SQL*Loader control file is a text file into which you place a description of the data to be loaded. You also use the control file to tell SQL*Loader which database tables and columns should receive the data that you are loading. Do not confuse SQL*Loader control files with database control files. In a way, it’s unfortunate that the same term is used in both cases. Database control files are binary files containing information
(2008)
Oracle SQL*Plus Pocket R...
Oracle SQL*Plus Pocket Reference Introduction The Oracle SQL*Plus Pocket Reference is a quick reference guide to SQL*Plus and to frequently used SQL statements. The purpose of this book is to help you find the syntax of specific language elements, including those in Oracle Data- base 10g. It is not a self-contained user guide; basic knowl- edge of SQL*Plus and SQL is assumed. For more detail and for tutorial information about SQL and SQL*Plus, see my book Oracle SQL*Plus: The Definitive Guide (O’Reilly). Mas- tering Oracle SQL by Sanjay Mishra and Alan Beaulieu (O’Reilly) is a good resource if you need advanced help with SQL. My own SQL Pocket Guide (O’Reilly) is, I hope, a good resource for those working with SQL on multiple platforms. SQL sections within this book include the following: Selecting Data Modeling Data Inserting Data Updating Data Deleting Data Merging Data (Oracle9i and Higher) Transaction Management The
(2004)
