Oracle7 Server Manager User's Guide

Library

Product

Contents

Index

Using the SQL Worksheet

Executing Commands in the SQL Worksheet
Using the Command History
Saving Your Work
Running Scripts from the SQL Worksheet

This chapter describes how to use the SQL Worksheet, which is part of Server Manager. It explains how to:

Start a SQL Worksheet

Enter and edit commands in a SQL Worksheet

Execute commands from a SQL Worksheet

Access commands you executed previously

Save your work

Run scripts from a SQL Worksheet

Start a System Monitor from a SQL Worksheet

The SQL Worksheet

Using the SQL Worksheet, you can enter, edit, and execute SQL and PL/SQL code. You can also execute the Server Manager commands described in Appendix A, "Server Manager Command Reference." You can also run scripts from the SQL Worksheet. The SQL Worksheet maintains a history of the commands you have issued, so you can easily retrieve and re-execute previous commands.

Starting a SQL Worksheet

You can start a SQL Worksheet from any Server Manager window by choosing New Worksheet from the File menu. The new worksheet is connected to the same database as the window from which you started the SQL Worksheet.

Using the SQL Worksheet

A SQL Worksheet window consists of the following elements:

Input pane

Output pane

Split bar

Execute button

Command History button

Run Script button

Worksheet pull-down menu

The following figure illustrates a SQL Worksheet window.

Figure 9 - 1. SQL Worksheet Window

The SQL Worksheet window is described below:

Input Pane

Upper window pane. Enter and edit commands in the input pane.

Output Pane

Lower window pane. Displays recently executed commands and output. Server Manager stores the last 32 KB of output for display in the output pane. The actual amount stored may vary by operating system.

Split Bar

Adjusts the relative sizes of the panes. Click the button and drag the split bar vertically to resize the panes.

Execute

Executes the command in the input pane. See "Executing Commands in the SQL Worksheet" for information about executing commands in a SQL Worksheet.

Command History

Displays the Command History dialog box, which displays previously executed commands. See "Using the Command History" for information about using the command history.

Run Script

Allows you to select and execute a script. See "Running Scripts from the SQL Worksheet" for information about running scripts from a SQL Worksheet.

The Worksheet Menu

The following figure illustrates the Worksheet pull-down menu.

Figure 9 - 2. Worksheet Pull-Down Menu

The Worksheet menu items are described below:

Command History

Displays the Command History dialog box, which displays previously executed commands. Equivalent to the Command History button. See "Using the Command History" for information about using the command history.

Execute

Executes the command in the input pane. Equivalent to the Execute button or the Enter key. If there are multiple commands in the input pane, commands are executed up to the first terminator (; or /). See "Executing Commands from the SQL Worksheet" for information about executing commands in a SQL Worksheet.

Run Script

Allows you to select and execute a script. Equivalent to the Run Script button. See "Running Scripts from the SQL Worksheet" for information about running scripts from a SQL Worksheet.

Spool

Writes output to a specified file. See "Saving Your Work" for information about spooling the output of a SQL Worksheet.

Stop Spooling

Closes the previously opened spool file.

Clear Lines Off Top

Clears the lines that have scrolled off the top of the output pane.

Write Log

Writes the output pane, including lines that have scrolled off the pane, to a specified file. See "Saving Your Work" for information about saving the output pane.

Write Selection

Writes selected text to a specified file. Text can be selected from the input or output pane. See "Saving Your Work" for information about saving selected text.

Previous Command

Retrieves the previous command from the command history and enters it in the input pane. The retrieved command replaces the entire contents of the input pane.

You can execute Previous Command repeatedly to work back through the command history. Previous Command is unavailable if you have currently retrieved the oldest command from the command history.

Next Command

Retrieves the next command from the command history and enters it in the input pane. The retrieved command replaces the entire contents of the input pane.

Next Command is unavailable if you have currently retrieved the most recent command from the command history.

Suggestion: Use the keyboard shortcuts to quickly access and execute commands from the command history.

Executing Commands in the SQL Worksheet

Server Manager executes commands you have entered in the input pane of a SQL Worksheet.

Entering Commands in the Input Pane

You can enter SQL, PL/SQL, and Server Manager commands in the input pane of a SQL Worksheet. A command entered in the input pane can contain tabs or carriage returns.

All standard text editing capabilities are available in the input pane of a SQL Worksheet. You can edit text in the input pane using the mouse, keyboard functions, and the Edit menu. In addition, you can select text from the output pane and paste it into the input pane.

Executing Commands in the Input Pane

To execute the command you have entered in the input pane, click Execute. You can also execute the command by choosing Execute from the Worksheet menu.

When you execute a command, the command and its output appear in the output pane. However, if you set the parameter ECHO to off, only the output of the command is displayed. For information about setting Server Manager parameters, see the SET command in Appendix A, "Server Manager Command Reference."

The following figure illustrates executing a SQL statement in a worksheet.

Figure 9 - 3. Executing a Command in the SQL Worksheet

After you execute a command, the command remains in the input pane, but is selected, as shown in Figure 9 - 3. You can then type in the next command, and it replaces the previous command. You do not need to delete the previous command unless you are running Server Manager under Windows.

Executing Server Manager Commands

In a SQL Worksheet you can execute the Server Manager commands described in Appendix A, "Server Manager Command Reference." Some of these commands behave differently when executed in a SQL Worksheet than when executed in line mode. These commands are summarized below:

Displays the standard file selection dialog box when you issue the @ command without specifying a filename.

CONNECT

Displays the Connect dialog box when you issue the CONNECT command without specifying complete connect information. For information about the Connect dialog box, see Chapter 1, "Overview of Server Manager."

HELP

Displays the Help window.

SPOOL

Displays the standard file selection dialog box for your platform when you issue the SPOOL command without specifying a filename.

RECOVER

If recovery is needed, displays the Recover dialog box when you issue the RECOVER command without arguments. Otherwise, an error message is generated.

EXIT

Closes the worksheet.

Note: The line mode command HOST is not available in the SQL Worksheet.

Additional Information: For information about the standard file selection dialog box for your system, see your operating system-specific documentation.

Connecting from a Worksheet

When you start a SQL Worksheet, you are automatically connected to the same database as the window from which you started the worksheet. You can change this connection by issuing the CONNECT command from the input pane of the worksheet. The title of the SQL Worksheet window also changes to reflect your new connection.

If you execute the CONNECT command from the input pane without any arguments, the Connect dialog box appears. You can use the Connect dialog box to specify a new connection for that worksheet. For a description of the Connect dialog box, see Chapter 1, "Overview of Server Manager." You can also specify the connection using arguments in the CONNECT command. For a description of the CONNECT command and its syntax, see Appendix A, "Server Manager Command Reference."

Note: The SQL Worksheet also contains the File pull-down menu, which is described. When you choose Connect from the File menu, the Connect dialog box also appears. However, when you choose Connect from the File menu, you are not changing your worksheet connection. In this case, the connection you are specifying is for a new Administration window.

Performing Recovery from the SQL Worksheet

When you issue the RECOVER command from a SQL Worksheet, the Recovery dialog box appears, if recovery is needed. The following figure illustrates the Recovery dialog box.

Figure 9 - 4. Recovery Dialog Box

From the Recovery dialog box, you can apply the next log file, apply all the log files, or cancel recovery. You can specify the name of the log file to apply or apply the default. For more information about the Recovery dialog box, see Chapter 6, "Backing Up and Recovering the Database."

Using the Command History

A SQL Worksheet maintains a history of the last 20 commands you have issued in that worksheet. To bring up the Command History dialog box, click Command History or choose Command History from the Worksheet menu.

The Command History dialog box contains a scrolling list of the commands in the worksheet's command history. The following figure illustrates the Command History dialog box.

Figure 9 - 5. Command History Dialog Box

The Command History dialog box is described below:

Retrieve Selection

Retrieves the selected command, or selected portion of a command, from the command history scrolling list and enters it in the input pane. See "Retrieving a Selection from the Command History" for more information about retrieving commands.

Cancel

Closes the dialog box without retrieving any text.

Selects the previous command in the command history.

Down

Selects the next command in the command history.

Help

Displays help information for the Command History dialog box.

Retrieving a Selection from the Command History

To retrieve an entire command from the Command History dialog box, position the cursor anywhere within the command and click Retrieve Selection. Alternatively, you can select the entire command and click Retrieve Selection.

To retrieve only a portion of a command from the Command History dialog box, select the text you wish to retrieve and click Retrieve Selection.

The text retrieved from the Command History dialog box is entered in the worksheet's input pane. If no text is selected in the input pane, the retrieved text is inserted at the cursor position. If you have selected text in the input pane, then the retrieved text replaces the selected text.

After you have retrieved text from the command history, you can edit or execute the command, as desired.

Retrieving a Command Using the Worksheet Menu

You can also retrieve commands without using the Command History dialog box. The Previous Command and Next Command menu items retrieve commands from the command history and enter them in the input pane, completely replacing the existing contents of the input pane. For more information on the Previous Command and Next Command menu items, see "The Worksheet Menu"

Saving Your Work

The Spool, Write Log, and Write Selection menu items allow you to save the work you have performed in a SQL Worksheet. Each of these Worksheet menu commands displays your platform's standard file selection dialog box, which you can use to specify the file in which to save your work.

The Spool menu item saves all output to a specified file. Server Manager continues to save the output of your worksheet until you choose Stop Spooling from the menu.

The Write Log menu item writes the current contents of your worksheet's output pane to a specified file. The output pane contains the last 32 KB of output and the last 100 lines of text. The actual amount may vary by operating system.

Any text that has scrolled out of the output pane is also written to the file. However, if you have used the Clear Lines Off Top menu item to clear any lines from the output pane, those lines are not written to the file.

The Write Selection menu item writes any text you have selected to a specified file. You can select text from the input or output pane.

Additional Information: Server Manager appends a file extension, such as .log or .txt, to the name of each file created by the Spool, Write Log, and Write Selection commands. These file extensions are operating system-dependent. Refer to your operating system-specific Oracle documentation for information about the file extensions for your system.

Running Scripts from the SQL Worksheet

From a SQL Worksheet, you can run any script that contains SQL, PL/SQL, or Server Manager commands. There are three ways to run scripts from a SQL Worksheet:

Clicking Run Script

Choosing Run Script from the Worksheet menu

Executing the Server Manager @ command from the input pane

Click the Run Script button or choose Run Script from the menu to bring up your platform's standard file selection dialog box, which you can then use to select a script to run.

You can also run a script from the input pane of a worksheet by entering an @ command followed by the script name. The following figure illustrates running a script from the input pane of a worksheet. If you enter an @ command without a script name, your platform's standard file selection dialog box appears to allow you to specify a script name.

Figure 9 - 6. Running a Script from the Input Pane

Note: In a script you can run other scripts. In the original script you can include the line @@second_scriptname to run another script called second_scriptname. The @@ command indicates that the second script is in the same directory as the original script.

Starting a Monitor from the SQL Worksheet

You can start any of the System Monitors from a SQL Worksheet using the Server Manager MONITOR command. If you issue the MONITOR command without specifying a monitor type, the Monitor dialog box appears. You can then select the type of monitor to start.

You can also issue the MONITOR command followed by the name of the monitor you want to start. For example, the statement MONITOR LOCK starts a lock monitor. For a list of the monitor names and abbreviations, see Table 1 - 4 .

You may start only one monitor of each type for each connection to an instance. If you try to start a monitor that has already been started, Server Manager brings that monitor window forward.

For a description of the System Monitors and the Monitor dialog box, see Part IV, "System Monitors."

Prev Next

Library

Product

Contents

Index