Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
 

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

 

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks