SQL Script Support in Oracle 10G Express Edition - Exporting and Importing of Scripts (Page 4 of 4 )
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.
Miscellaneous items
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.
Summary
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.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
