Tips for uploading csv data with sql developer

Use Sql developer 4.0 with pre-installed Java, this will help you for good extend.

Q: How to upload data to table ?
Ans: From Sql Developer, select the required table and check for “Import”. After that, flow with the flow 😉

If you are trying upload csv file using in-built tools, few things

  1. Which important Data, make sure you set you upload max rows and display rows in limit.(Max rows to be uploaded should > rows in you csv file)
  2. Note – if any Date characters are there, make sure to give date format of column “DD-MON-YYY” for ’14-APR-2006′ ( This is in the export process, -@ 4th stage, make sure you test it before upload)

If you are trying to upload data as insert – Sql format, you remember the follow

  1. “SET SCAN OFF”, To prevent system asking you for entering values. If sql querying is having any ‘&’, It will think that we are going to input something there.
  2. “Set NOLOG”, only if you are sure.In case of csv import with built-in tools of sql developer – you don’t need to bother much.
  3. Commit, after 2 ~ 3k records, to be safer side if you are expecting any chances of errors.
Advertisements

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