| Oracle® HTML DB User's Guide Release 1.6 Part Number B14303-02 |
|
|
View PDF |
| Oracle® HTML DB User's Guide Release 1.6 Part Number B14303-02 |
|
|
View PDF |
This section describes how to use Data Workshop to import data and export data using a Web Browser.
This section contains the following topics:
Oracle HTML DB renders information stored in an Oracle database to create a collection of database-driven Web pages called an application. Using Data Workshop you can import data into and export data from the hosted database. Supported import formats include:
Text such as comma or tab delimited data
XML documents
Spreadsheets
Supported export formats include:
Text such as comma or tab delimited data
XML documents
To access Data Workshop:
Click the Data Workshop icon on the Workspace home page. (See Figure 4-1.)
Under Data Import and Data Export, click the appropriate link.
You can use Data Workshop to import text files, XML documents, and data stored in a spreadsheet into an Oracle database.
Topics in this section include:
For files less than 30KB, you can copy and paste tab delimited data directly into the Import Text Wizard. For files larger than 30KB, you must upload a separate file.
To load a text file:
Data Workshop supports the import of XML documents adhering to the Canonical XML specification.
To import an XML document:
You can load spreadsheet data by either copying and pasting text, or by importing a 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.
To import spreadsheet data:
Click Data Workshop on the Workspace home page.
Under Data Import, click Import Spreadsheet Data.
Under Import to, select either Existing table or New table.
Under Import from, select either Upload file or Copy and paste.
Follow the on-screen instructions.
You can also use Data Workshop to export the contents of a table to a text file or XML document.
Topics in this section include:
Use the Export Text Data Wizard to export the contents of a table to a text file. For example, you could export an entire table to a comma delimited file (.csv).
To export a table to a text file:
Click Data Workshop on the Workspace home page.
Under Data Export, click Export Text Data.
The Export Text Data Wizard appears.
Follow the on-screen instructions.
You select the schema and choose the table and columns to be exported. You can also specify the type of separator to be used to separate column values as well as whether column text strings are identified using single or double quotation marks.
Use the Export XML Wizard to export the contents of a table to an XML document adhering to the Canonical XML specification.
To export a table to an XML document:
Click Data Workshop on the Workspace home page.
Under Data Import, click XML Export.
Follow the on-screen instructions.
You select the schema and choose the table and columns to be exported.
