Chapter 9. SQL*Plus Formatting
Terms You Need to Understand
✓ Environmental settings
✓ Scripting
✓ Variable substitution
✓ Session
✓ &, &&, DEFINE, and UNDEFINE
✓ @, @@, RUN, and START
✓ COLUMN
Concepts You Need to Master
✓ Environmental settings are set for each execution of a SQL*Plus program
✓ Reconnecting within SQL*Plus does not reinitialize environmental settings
✓ Set environment variables with the SET command
✓ Creating scripts in SQL*Plus
✓ Editing scripts in SQL*Plus
✓ Executing scripts in SQL*Plus
✓ Variable substitution in SQL*Plus
✓ Formatting using the COLUMN command
✓ Differences between SQL*Plus and iSQL*Plus
This chapter covers advanced formatting using SQL*Plus tools for database administrators, developers, and report writers. There are several ...
Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
