Creating HTML Reports

Beginning with Oracle8 i Database Release 2 (Version 8.1.6), you can use SQL*Plus to generate HTML pages. Instead of spooling a report to a printer, you can write it to an HTML file for viewing on your corporate intranet. With a bit of creativity and some cascading style sheet (CSS) skills, you can generate some good-looking web pages. In this chapter, I'll revisit some of the character-based reports from Chapter 5 and show some ways to render those same reports as HTML pages.

CSS is a mechanism for specifying the format of an HTML document. One reason CSS works well for SQL*Plus-generated HTML is because your CSS styles can reside in a file separate from the spool file generated by SQL*Plus, greatly reducing the likelihood that you will need to modify your SQL*Plus script to effect formatting changes. To learn more about CSS, read Eric Meyer's Cascading Style Sheets: The Definitive Guide (O'Reilly) and Eric Meyer on CSS (New Riders).

     

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

---

Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)

• SWT Event Handling, Threading, and Displays
• Tables
• Trees
• Dialogs
• Scales, Sliders, and Progress Bars

Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)

• Cluster Redundancy Designs
• Configuring Cisco IPMA for Shared-Line Support
• Summary
• User Report Configuration

Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More

• Preventing Name Collisions with Namespaces
• Converting Between Time Zones
• Creating a Singleton Class
• Deleting or Renaming a File
• Extracting a Filename from a Full Path

AutoCAD 2005 and AutoCAD LT 2005. No Experience Required

• Getting to Know AutoCAD
• Grouping Objects into Blocks
• Generating Elevations
• Using Layouts to Set Up a Print
• Printing an AutoCAD Drawing

MPLS Configuration on Cisco IOS Software

• Basic MPLS VPN Overview and Configuration
• Case Study-Hub and Spoke MPLS VPN Network Using BGP PE-CE Routing for Sites Using Unique AS Numbers
• Option 4: Non-VPN Transit Provider
• Case Study-Inter-AS Implementing Route-Reflector and BGP Confederation in Provider Networks
• Case Study 1: Implementing Multicast Support for MPLS VPNs

Digital Character Animation 3 (No. 3)

• Chapter Two. Modeling Characters
• Chapter Three. Rigging Characters
• Conclusion
• Acting and the Body
• Developing a Story

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