Oracle - The SQL*Plus Break Command - initcap column heading

Home
E-mail Us
Oracle Articles
New Oracle Articles

Oracle Training
Oracle Tips
Oracle Forum
Class Catalog

Remote DBA
Oracle Tuning
Emergency 911
RAC Support
Apps Support
Analysis
Design
Implementation
Oracle Support

SQL Tuning
Security
Oracle UNIX
Oracle Linux
Monitoring
Remote support
Remote plans
Remote services
Application Server
Applications
Oracle Forms
Oracle Portal
App Upgrades
SQL Server
Oracle Concepts
Software Support
Remote Support
Development
Implementation

Consulting Staff
Consulting Prices
Help Wanted!

Oracle Posters
Oracle Books
Oracle Scripts
Ion
Excel-DB

Don Burleson Blog

Oracle Database Tips by Donald Burleson

The SQL*Plus Break Command

I can add some flash to this report by using the SQL*Plus BREAK command. The BREAK command tells SQL*Plus to print a column once, then wait for the column to change. Each time the column changes, SQL*Plus will print the new value once after skipping the defined number of lines. Since this is another SQL*Plus command, it goes before the query in our script. I am going to implement the BREAK command on the Store Name and skip two lines between stores.

* state_report.sql

-- Books, By Store, Filter by State, with Break

-- state_report.sql

set pages 999 line 74 feedback off verify off

accept statecode prompt "Enter a State: "

column c1 heading "Store Name" format a28

column c2 heading "Book Title" format a34

break on c1 skip 2

select distinct

initcap (store_name) c1,

initcap (book_title) c2

from

sales join store on (store.store_key = sales.store_key)

join book on (sales.book_key = book.book_key)

where

Get the Complete
Oracle SQL Tuning Information

The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.

��