The Product User Profile

In addition to the standard database security Oracle provides and enforces for all database objects ”tables, views, and the like ”Oracle provides an application security scheme for SQL*Plus. This allows you to control the specific commands a SQL*Plus user is allowed to execute. At the core of the SQL*Plus application security scheme is the product user profile.

     

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

show all menu

Previous page

Table of content

Next page

---

Oracle SQL*Plus: The Definitive Guide (Definitive Guides)

ISBN: 0596007469
EAN: 2147483647

Year: N/A
Pages: 151

Authors: Jonathan Gennick

BUY ON AMAZON

---

SQL Hacks

• Hack 31. Disaggregate a COUNT
• Hack 57. Generate Unique Sequential Numbers
• Hack 78. Break It Down by Range
• Hack 79. Identify Updates Uniquely
• Hack 89. Choose Any Three of Five

Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference

• Local Area Network (LAN) Technologies
• Internet Protocol (IP) Routing
• Transmission Control Protocol (TCP) Retransmission and Time-Out
• Domain Name System (DNS)
• Virtual Private Networks (VPNs)

MySQL Cookbook

• Producing HTML Output
• Finding Dates for Days of the Current Week
• Floating Specific Values to the Head or Tail of the Sort Order
• Using Patterns to Match Broad Content Types
• Using MySQL-Based Storage with the PHP Session Manager

Mapping Hacks: Tips & Tools for Electronic Cartography

• Hack 28. Experiment with Different Cartographic Projections
• Hack 58. Dont Lose Your Tracklogs!
• Hack 67. Seamless Data Download from the USGS
• Hack 76. Explore the Effects of Global Warming
• Hack 85. Geocode U.S. Locations with the GNIS

Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain

• Relationships in the Supply Chain
• The Internationalization of the Retail Supply Chain
• Logistics in Tesco: Past, Present and Future
• Rethinking Efficient Replenishment in the Grocery Sector
• Transforming Technologies: Retail Exchanges and RFID

Comparing, Designing, and Deploying VPNs

• AToM Pseudowire Operation
• Deploying AToM Pseudowires
• A Detailed Examination of MPLS Layer 3 VPNs
• Operation of L2TP Voluntary/Client-Initiated Tunnel Mode
• Enabling SSL VPNs (WebVPN) on Cisco IOS Devices

Flylib.com © 2008-2020.
If you may any questions please contact us: [e-mail]

Privacy policy

This website uses cookies. Click here to find out more.
Accept cookies