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.

     

Introduction to SQL*Plus

Command-Line SQL*Plus

Browser-Based SQL*Plus

A Lightning SQL Tutorial

Generating Reports with SQL*Plus

Creating HTML Reports

Advanced Reports

Writing SQL*Plus Scripts

Extracting and Loading Data

Exploring Your Database

Advanced Scripting

Tuning and Timing

The Product User Profile

Customizing Your SQL*Plus Environment

Appendix A. SQL*Plus Command Reference

Appendix B. SQL*Plus Format Elements



Oracle SQL Plus The Definitive Guide, 2nd Edition
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
ISBN: 0596007469
EAN: 2147483647
Year: N/A
Pages: 151

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net