The SQL*Plus Worksheet

Oracle's SQL*Plus Worksheet is a straight-forward, easy-to-use, graphical user interface for SQL. It is an Oracle 10 client. Although our server is Oracle version 12, the version 10 client, which is installed on the School's LinuxMixt 13 Mate Workstations in Teaching Laboratory #3, works perfectly well with it.

Running the SQL*Plus Worksheet on Linux

You can run the SQL*Plus Worksheet on any LinuxMint PC in the Linux Teaching Lab, C/2.08.

SQL*Plus Worksheet is started from the Applications menu.

Click the left mouse button down over the Mint menu button on the bottom edge panel to open the Menu panel.

If the panel shows Favourites, click on All applications to see the applications menus.

Find the School Apps category and move the left mouse over it to show a list of local applications.

Choose SQL*Plus Worksheet and click the left button.

Running the SQL*Plus Worksheet from a Linux Terminal

The SQL*Plus Worksheet can be invoked from the command line in a Linux terminal.

oemapp worksheet

The terminal must be associated with a graphical display (ie the X11 DISPLAY variable must be set) or SQL*Plus Worksheet will fail to run.

Logging-in to SQL*Plus Worksheet

The Worksheet starts and asks you for your Oracle Username, Password and Service.

Enter your Oracle account name in the Username field. This is normally the same as your standard University user name. Enter your Oracle password in the Password field. (This is different from your University password.) Type csora12edu in the Service field. csora12edu is an Oracle SID identifier. It is automatically translated by the School's workstations to the correct Oracle connection string for the School's Oracle server.

When you have completed all the fields click the Image ok-oem button. To abandon the SQL*Plus Worksheet program, click on Image cancel-oem.

Using the SQL*Plus Worksheet

If you have typed the correct details, the Worksheet connects to Oracle.

The SQL*Plus Worksheet window is divided into two panels. The upper panel is where you write SQL input and the lower panel is where Oracle SQL output will appear. They are known as the input and output panels.

Type your SQL commands in the Worksheet input panel. Be sure to delete any earlier commands that still appear in the window.

To run the SQL command click on the Execute icon on the left, Image sqlw6, or choose Execute from the Worksheet pull-down menu.

The results are displayed in the output panel.

You can edit your SQL statements in the input panel using the mouse to highlight and position text in the usual way. The Edit pull-down menu has Cut, Paste and other editing functions.

You may also copy the contents of the input panel to a file. This SQL file can later be opened by the Worksheet so that the commands can be executed again.

Choose Save input as from the File menu and then enter a file name into the file chooser.

The Linux file chooser shown here is different from the standard Mate or GNOME chooser. It looks different but has similar features including areas for navigating folders and for specifying a file name.

Similarly, you can save the contents of the output panel to a file. You can do this, for example, if you need to present output as part of your coursework.

Terminating the Worksheet

When you have finished with the SQL*Plus Worksheet choose the Exit menu option under the File pull-down menu.

© Robert Evans, Cardiff School of Computer Science & Informatics, Cardiff University, 2014-09-15