Oracle Server Manager User's Guide

Contents Index Home Previous Next

Using Server Manager in Line Mode

In line mode you can execute the Server Manager commands described in Appendix A, "Server Manager Command Reference." In addition, you can execute SQL statements and PL/SQL code.

Entering Server Manager Commands

Single-line Server Manager commands do not require punctuation or terminators. A Server Manager command may span more than one line if you use a backslash (\) at the end of each line to indicate a continuation.

Entering SQL or PL/SQL Code

You can enter single-line or multiple-line SQL statements in line mode. Continuation characters are not needed in multiple-line SQL statements. To end a SQL statement and execute it, either type a semicolon (;) at the end of the statement or type a slash (/) by itself on the last input line.

To execute PL/SQL code, type a slash (/) by itself on the last input line.

Running Scripts

In line mode you can also run scripts using the @ command. For example, to run the script TEST.SQL, issue the statement @test. If you do not specify a script name, Server Manager prompts you for one, as in the following example:

SVRMGR> @
Name of script file: test


Contents Index Home Previous Next