O'Reilly logo

Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) by Gavin Powell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required