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.
- Oracle Database.
- TOAD tool configured to database.
Go to Database->Import -> Import table Data
Select the schema, Object Type and Object Name
Click Next , Select the File, Click Next, Specify the Source Data Details and check the excel sheets, Columns and then Execute
At last you will find Execute Button. Press It to add the rows
Exporting from database
Go to Toad Menu, Database-> Schema Browser
Select Schema, Table
After Selecting right click table name -> Export Data -> Choose Destination and click Ok
You can also add a additional where clause to specify the rows.
You can also try Create Script which gives you the DDL Statements like(Create table )
Thank you for Reading…