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
CISSP Exam Cram 2
About This Book
Exam Prep Questions
Penetration Testing
Auditing and Monitoring
Answers to Practice Exam Questions
Metrics and Models in Software Quality Engineering (2nd Edition)
Some Basic Measures
Examples of Metrics Programs
Test Compression Factor
Measuring Process Capability
Measuring Process Adoption
Lotus Notes and Domino 6 Development (2nd Edition)
Retrieving Data with @DbColumn and @DbLookup
Writing Java for Domino Applications
Creating the Activity
Hiding the Design of Your Application
Frameset Tags
Cisco CallManager Fundamentals (2nd Edition)
Miscellaneous Solutions
Cisco VT Advantage
System Tools
SIP Signaling
SCCP Call Signaling
Java Concurrency in Practice
Introduction
Synchronized Collections
Concurrent Collections
Finding Exploitable Parallelism
Summary
User Interfaces in C#: Windows Forms and Custom Controls
Designing with Classes and Tiers
Control Class Basics
Classic Controls
Forms
Custom Controls
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