Flylib.com
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
ISBN: 0596007469
EAN: 2147483647
Year: N/A
Pages: 151
Authors:
Jonathan Gennick
BUY ON AMAZON
Introduction to SQL*Plus
Introduction to SQL*Plus
What Is SQL*Plus?
History of SQL*Plus
Why Master SQL*Plus?
Creating and Loading the Sample Tables
Command-Line SQL*Plus
Command-Line SQL*Plus
Starting Command-Line SQL*Plus
Starting Windows SQL*Plus
Some Basic SQL*Plus Commands
Running SQL Queries
Working with PL/SQL
The SQL Buffer
Line Editing
Executing the Statement in the Buffer
Saving and Retrieving the Buffer
The EDIT Command
Executing a Script
The Working Directory
Browser-Based SQL*Plus
Browser-Based SQL*Plus
Starting iSQL*Plus
Executing SQL*Plus Commands
Running SQL Queries
Working with PL/SQL
Executing Scripts
iSQL*Plus Command History
A Lightning SQL Tutorial
A Lightning SQL Tutorial
Data Manipulation Statements
Transactions
The Concept of Null
Table Joins
Sorting Query Results
Grouping and Summarizing
Subqueries
Unions
To Learn More
Generating Reports with SQL*Plus
Generating Reports with SQL*Plus
Following a Methodology
Saving Your Work
Designing a Simple Report
Master/Detail Reports
Creating HTML Reports
Creating HTML Reports
Getting the Data into an HTML Table
Generating the Entire Page
Another Approach to Headers
Master/Detail Reports in HTML
Advanced Reports
Advanced Reports
Totals and Subtotals
Getting the Current Date into a Header
Report Headers and Footers
Formatting Object Columns
Summary Reports
Taking Advantage of Unions
Writing SQL*Plus Scripts
Writing SQL*Plus Scripts
Why Write Scripts?
Using Substitution Variables
Prompting for Values
Cleaning Up the Display
Executing a Script
Controlling Variable Substitution
Commenting Your Scripts
Resetting Your SQL*Plus Environment
Scripting Issues with iSQL*Plus
Extracting and Loading Data
Extracting and Loading Data
Types of Output Files
Limitations of SQL*Plus
Extracting the Data
An Excel-Specific HTML Hack
Reloading the Data
Exploring Your Database
Exploring Your Database
The DESCRIBE Command
Oracles Data Dictionary Views
Tables
Table Constraints
Indexes
Triggers
Synonyms
Table Security
Scripting the Data Dictionary
Using SQL to Write SQL
The Master Key
Advanced Scripting
Advanced Scripting
Bind Variables
Branching in SQL*Plus
Looping in SQL*Plus
Validating and Parsing User Input
Error Handling
Returning Values to Unix
Tuning and Timing
Tuning and Timing
Using SQL*Plus Timers
Using EXPLAIN PLAN
Using AUTOTRACE
Improving on EXPLAIN PLAN Results
Where to Find More Tuning Information
The Product User Profile
The Product User Profile
What Is the Product User Profile?
Using the Product User Profile
Customizing Your SQL*Plus Environment
Customizing Your SQL*Plus Environment
SQL*Plus Settings You Can Control
The Site and User Profiles
Environment Variables That Affect SQL*Plus
Windows GUI SQL*Plus
iSQL*Plus User Preferences
Appendix A. SQL*Plus Command Reference
Section A.1. The Command to Invoke SQL*Plus
Section A.2. Commands You Can Issue Within SQL*Plus
Appendix B. SQL*Plus Format Elements
Appendix B. SQL*Plus Format Elements
Section B.1. Formatting Numbers
Section B.2. Formatting Character Strings
Section B.3. Formatting Dates
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
ISBN: 0596007469
EAN: 2147483647
Year: N/A
Pages: 151
Authors:
Jonathan Gennick
BUY ON AMAZON
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Connecting to a Text File
Accessing Deleted Rows in a DataTable
Updating Data Asynchronously Using Message Queuing
Binding Data to a Web Forms DataList
Determining the Length of Columns in a SQL Server Table
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Introduction
Splitting a String
Performing Date and Time Arithmetic
Mapping strings to Other Things
Formatting Floating-Point Output
C++ GUI Programming with Qt 3
Signals and Slots in Depth
Dynamic Dialogs
Creating Menus and Toolbars
Reading XML with SAX
Using Qt Assistant for Powerful Online Help
Cisco CallManager Fundamentals (2nd Edition)
Call Routing
Call Hunting Constructs
Hints on Processing CDR Data
Cisco CallManager Feature List
QSIG
Microsoft VBScript Professional Projects
Project Case Study Analyzing Application Logs
Scheduling Script Execution
Maintaining a 30-Day Summary Log Archive
Converting Reports to HTML Pages
Report Distribution and Remote Archive Management
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Working with 1-D and 2-D Shapes
Laying Out Office Spaces
Key Points
Glossary
About the Authors
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies