Home arrow Oracle arrow 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.

  1. SQL Script Support in Oracle 10G Express Edition
  2. Sample scripts
  3. Creating a script
  4. Exporting and Importing of Scripts
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 35
June 28, 2006

print this article



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.




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.

>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: