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.
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.
|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 button. To abandon the SQL*Plus Worksheet program, click on .
|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, , 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.
|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