Loading Data

Oracle Database Express Edition enables Sheila to load data by using the utilities that are available in the Application Express interface. The utilities allow her to:

• Load XML data

  You can use Utilities> Load to load data from a XML document into an Oracle database. It is usually used to load data that has been unloaded from a table either to fix data errors or to insert into a different table. Other XML documents can also be used but the XML has to conform to the table exactly and has to have the same document structure as the file created by the Unload process. For more information on Unloading please see the Removing data section

• Load data from a spreadsheet

  You can use Utilities> Load to load data from a XML document into an Oracle database. You can use Utilities> Load to import data stored in a spreadsheet into an Oracle database. You can load spreadsheet data by either copying and pasting text, or by importing a spreadsheet file. To copy and paste text, the spreadsheet file must be less than 30KB. For files larger than 30KB, you can import the file in a delimited format (such as comma delimited (.csv) or tab delimited), upload the file, and then load the data into a new or existing table.

• Load data from a text file

  You can use Utilities> Load to load data from a XML document into an Oracle database. You can use the Utilities > Load page to load text files. For files less than 30KB, you can copy and paste tab delimited data directly into the Load Text page. For files larger than 30KB, you must upload a separate file.