HomeOracle Page 4 - SQL Script Support in Oracle 10G Express Edition
Exporting and Importing of Scripts - Oracle
In an earlier tutorial we saw how to use SQL commands in the Oracle 10g Express Edition, or simply Oracle XE. We also saw how to use the PL/SQL commands as well. In another tutorial we saw how to use the Query Builder, the graphical interface for fashioning and running SQL in the Oracle XE. The present tutorial describes the SQL scripting support in Oracle XE. In order to bring out the basic features of scripting support a few example scripts are considered in the discussion.
You can both export files from and import them into Oracle 10G XE by clicking the appropriate buttons while you are in the script editor. The next picture illustrates exporting out of the WLOOP script.
Place a check mark against the script you want to export, or you may also export the whole lot, and click on export to open up the next screen.
Now clicking on the Export ALL button opens up the following two windows (one on top of the other, shown displaced in the picture). When you click save, it saves it to a folder named download (but what if I do not have a directory called "download"?).
Importing is just as easy. Clicking on Import will bring up the window where you browse to find the script as shown. Again the dialog to choose the file from opens to the "download" directory. However, in a multi-user application these export/import functionalities would probably allow for the exchange of scripts between users.
The script quotas window shows your personal quota, used or otherwise. This is a useful number to be aware of, if you are using the database under high usage conditions. This window for this infrequent user is shown in the next pciture.
Another feature of the UI that you should be aware of is the breadcrumbs, a very useful navigational feature that allows you to traverse the hierarchy of windows. You could move through the windows in a way very similar to navigational buttons by clicking on the crumbs.
The SQL Command, Query Editor, and SQL Scripts provide all the needed SQL Support. The interfaces are very easy to use, with excellent navigational features. The script editor includes line numbering, undo, redo, and find features which are excellent aids in scripting. Oracle's online support for this product is terrific. One email I sent to Oracle got me a response in a record time of under 15 minutes. Unbelievable, but true.