Importing and exporting data by TOAD(for oracle DB)


Inserting into database using Toad

When your Requirement is to import the data inside a database and you have your data in spreadsheet the below is very easy.

Requirements

  • Oracle Database.
  • TOAD tool configured to database.

Importing data

 

Go to Database->Import -> Import table Data

1

Select the schema, Object Type and Object Name

2

Click Next , Select the File, Click Next, Specify the Source Data Details and check the excel sheets, Columns and then Execute

3

 

At last you will find Execute Button. Press It to add the rows

Exporting from database

Go to Toad Menu, Database-> Schema Browser

00

 

Select Schema, Table

11

After Selecting right click table name -> Export  Data -> Choose Destination and click Ok

22

 

You can also add a additional where clause to specify the rows.

33

You can also try Create Script which gives you the DDL Statements like(Create table )

Thank you for Reading…

 

About pacesettergraam

A good and realistic person

Posted on September 27, 2013, in Oracle, SQL/PLSQL and tagged , , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: