Book Statistics
2 Views
0 Comments
0 Rating

Oracle SQL Plus: The Definitive Guide

Description

 

This definitive guide to SQL*Plus, Oracle's interactive query tool, shows Oracle developers and database administrators how to take full advantage of the power and flexibility of this popular tool. Despite the wide availability and usage of SQL*Plus, few developers and DBAs know how powerful it really is. This book introduces SQL*Plus, includes a quick reference to its syntax options, and provides chapters that describe, step-by-step, how to perform all the tasks Oracle developers and DBAs want to perform with SQL*Plus -- and maybe some they didn't realize they COULD perform. You will learn how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, customize your SQL*Plus environment, and use the SQL*Plus administrative features (new in Oracle8i). Oracle SQL*Plus: The Definitive Guide is an indispensable resource for readers who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and a quick reference for every user.

Keywords

SQL*Plus History Master SQL*Plus SQL*Plus Commands SQL Queries SQL Buffer Line Editing Buffer Retrieving Executing Methodology Report Formatting Reporting Topics Scripts Substitution Variables Values DEFINE UNDEFINE Commands Variable Substitution Loading Data DESCRIBE Command Data Dictionary Views Triggers Synonyms Table Security Scripting Bind Variables Error Handling Tuning Timing EXPLAIN PLAN AUTOTRACE SET Command SHOW Command Command Reference

Download & Read Options

Oracle SQLPlus The Definitive Guide.pdf

PDF

Reader's Comments (0)

Login to Comment
No Comments Yet

Be the first to share your thoughts about this book!