Miscellaneous SQL*Plus Commands

Today's examples use a few new commands. These commands, known as SQL*Plus commands, are specific to Personal Oracle and control the format of your output results. (See Bonus Day 3, “Using Oracle SQL*Plus to Satisfy Reporting Needs.”) SQL*Plus commands are issued at the SQL> prompt, or they can be used in a file.

Note

Although these commands are specific to Oracle, similar commands are available in other implementations, for example, Transact-SQL. (See Bonus Day 5, “An Introduction to Transact-SQL.”)

SET ECHO ON/OFF

When you use SET ECHO ON, you will see your SQL statements as they execute. SET ECHO OFF means that ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition 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.