customer_report

customer_report - COLUMN c_city HEADING 'City' FORMAT A12...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
-- EXTRA EXAMPLE TTITLE CENTER 'Clearwater Traders' SKIP 1 - CENTER '******************' SKIP 2 - LEFT 'Customer Report' L BTITLE CENTER '* * * Confidential * * *' B SET LINESIZE 100 SET PAGESIZE 25 S COLUMN c_id HEADING 'ID' FORMAT 999 COLUMN c_last HEADING 'Last Name' FORMAT A10 COLUMN c_first HEADING 'First Name' FORMAT A10 COLUMN c_mi HEADING 'MI' FORMAT A2 COLUMN c_address HEADING 'Address' FORMAT A18
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: COLUMN c_city HEADING 'City' FORMAT A12 COLUMN c_state HEADING 'St' COLUMN c_zip HEADING 'Zip' FORMAT A5 COLUMN c_dphone HEADING 'Day Phone' FORMAT A12 COLUMN c_ephone HEADING 'Eve. Phone' FORMAT A12 C SELECT c_id,c_last, c_first, c_mi, c_address, c_city, c_state, c_zip, c_dphone, c_ephone FROM customer;...
View Full Document

Ask a homework question - tutors are online