8
Using SQL*Plus
In this chapter:
What are environmental settings for SQL*Plus formatting?
How are variables used in SQL*Plus?
How are scripts used in SQL*Plus?
How are reports formatted in SQL*Plus?
How is iSQL*Plus used for reporting?
This chapter shows you how to use the environmental settings, variables, and special SQL*Plus commands to generate acceptable output and reports. Examples in this book use both SQL*Plus Worksheet and SQL*Plus. SQL*Plus Worksheet is more of an end-user tool. A final part of this chapter shows some brief example use of iSQL*Plus.
Let’s start by looking at some environmental settings.
8.1 Environmental Settings
An environmental variable is set for the duration of a session using the SET command or as a default. ...
Get Oracle SQL 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.