 |
|
Export from SQL Developer to csv file
Oracle Tips by Burleson |
Exporting Data
Now that there is a file for the DDL, data can be
exported from any tables that may be needed. This data is being
exported so it can be loaded into our production HTML DB server. This
function is another part of the SQL Workshop utilities. Navigate to
the utility by using the buttons or menus to follow the path SQL
Workshop à Utilities
à Data Import/Export.
Within this section are three choices: Import;
Export; and viewing the Import Repository. Although the Export
function will be covered here now, the Import function will be used
later to load files into the Import Repository.
1.
To begin the export procedure, navigate to the Export To Text
wizard via SQL Workshop à
Utilities à Data
Import/Export à Export
à Export to Text.
2.
On the Schema page, choose the schema and click Next. The
example schema is EASYHDB.
3.
On the Table Name page, choose the Table to export and click
Next. The selected table name for this example is CONFERENCE_RSVP.
4.
On the Columns page, select the columns to export and click
Next. For this example, chose all columns.
5.
On the Options page, information will be entered to identify
how to format the date in the export file. When the options have been
set, click the Export Data button.
Figure 14.6 shows the options available
for the formatting of the export file. A comma is a common separator
as well as the “|” character. The Optionally Enclosed By field should
be used if the data being exported includes characters the same as the
delimiter. For example, if there is a name column that is storing
data like “Wilson, Julie” there will be a problem on import because of
the extra comma in the middle of the text. Enclosing the text with a
double-quote makes it look like one piece of data when being imported.
6.
The default file name being exported will be that of the table
name plus the file extension. Click on the Save button and save the
file.
In the example above, the data was exported to a
comma separated value (CSV) file. It is also possible to choose to
export the file to an XML format.
The above book excerpt is from:
Easy HTML-DB
Oracle Application Express
Create
Dynamic Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
|
