Programming Oracle® Triggers and Stored Procedures, Third Edition

Chapter Two. Interacting with Oracle

2.1 SIMPLIFY SQL*PLUS FOR YOURSELF ON WINDOWS

2.2 CONNECTING

2.3 CONNECTING TO AN INFRASTRUCTURE

2.4 DISCONNECTING

2.5 COMMAND LINE

2.6 CHANGES ON THE COMMAND LINE

2.7 SCRIPTS

2.8 SCRIPT OUTPUT

2.9 COMMAND LINE ARGUMENTS

2.10 SQL*PLUS WITH KORN SHELL

2.11 BATCH COMMAND FILES

2.12 SQL*PLUS WITH ACTIVE STATE PERL

2.13 PRIVILEGES

2.14 DUAL

2.15 AUTOTRACE

The purpose of this chapter is twofold: demonstrate the interactive features of SQL*Plus and, show how to incorporate SQL*Plus into other scripting languages such as Korn Shell and Perl.