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
ERP and Data Warehousing in Organizations: Issues and Challenges
Challenging the Unpredictable: Changeable Order Management Systems
The Second Wave ERP Market: An Australian Viewpoint
Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
Context Management of ERP Processes in Virtual Communities
Healthcare Information: From Administrative to Practice Databases
Software Configuration Management
Introduction to Software Configuration Management
A Practical Approach to Documentation and Configuration Status Accounting
Metrics and Configuration Management Reference
CM Automation
Appendix L Software Requirements Changes
Data Structures and Algorithms in Java
Interfaces
Problems
A.4. Interacting with the User
A.6. Methods and Breaking Out
C.5. Upper Limit on Sum of a Function
Competency-Based Human Resource Management
Competency-Based Employee Recruitment and Selection
The Transformation to Competency-Based HR Management
Appendix B Further Suggestions on Employee Development
Appendix C Examples of Life-Career Assessment Exercises
Appendix D Employee Development and Succession Management
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 20. Track Official Storm Reporting
Hack 28. How Big Is That, Exactly?
Hack 37. View Your GPS Tracklogs in Google Maps
Hack 39. Track Your Every Move with Google Earth
Hack 63. Read and Write Markers from a MySQL Database
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Relationships in the Supply Chain
Market Orientation and Supply Chain Management in the Fashion Industry
The Development of E-tail Logistics
Transforming Technologies: Retail Exchanges and RFID
Enterprise Resource Planning (ERP) Systems: Issues in Implementation
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