Skip to Content
Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts
book

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

by John Adolph Palinski
August 2002
Intermediate to advanced content levelIntermediate to advanced
528 pages
10h 12m
English
Addison-Wesley Professional
Content preview from Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Chapter 11

A1:
 set linesize 132 column sysdate noprint new_val day column last_name hea ‘Last Name’ for a15 column first_name hea ‘First Name’ for a10 column employment_date hea ‘Employment| Date’ jus center format a10 column current_position hea ‘Current Position’ format a18 column wages hea ‘Wages’ format $999,999.99 column purchase_date hea ‘Tool|Purchase| Date’ format a10 jus center column tool_name hea ‘Tool Name’ column tool_cost hea ‘Cost of|Tool’ format $999.99 jus right column department_name hea ‘Department Name’ break on department_name on last_name on first_name - on employment_date on current_position on wages compute sum label ‘Dept Total’ of tool_cost on department_name ttitle left day center ‘Departmental Tool Purchases’ btitle ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Expert PL/SQL Practices for Oracle Developers and DBAs

Expert PL/SQL Practices for Oracle Developers and DBAs

John Beresniewicz, Adrian Billington, Martin Büchi, Melanie Caffrey, Ron Crisco, Lewis Cunningham, Dominic Delmolino, Sue Harper, Torben Holm, Connor McDonald, Arup Nanda, Stephan Petit, Michael Rosenblum, Robyn Sands, Riyaj Shamsudeen
Beginning Oracle SQL: for Oracle Database 12c, Third Edition

Beginning Oracle SQL: for Oracle Database 12c, Third Edition

Lex De Haan, Tim Gorman, Inger Jørgensen, Melanie Caffrey

Publisher Resources

ISBN: 0201752948Purchase book