HomeНаука и техникаRelated VideosMore From: Oracle Learning Library

Importing Data from Excel into Oracle Database using SQL Developer 4.1

67 ratings | 65872 views
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio. Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Html code for embedding videos on your blog
Text Comments (7)
mimz ressamhae (4 months ago)
thanks
Great!
19mad92 (1 year ago)
That is a great tutorial thank you! At work we got loads of triggers in our db and what if I want to import a bulk of data updates like this into a table? Do the triggers execute?
Mark Stewart (2 years ago)
When reviewing the individual fields, you should have increased the size for name, etc. from 11 bytes to 50 or more.
Msstaui Db (2 years ago)
if the excel is updated how do we reload
Mark Stewart (2 years ago)
+Msstaui Db -- If the data is not maintained in Oracle, just go through same steps, but just choose "INSERT SCRIPT" instead of INSERT, and you would also have to delete existing rows from first import before running the insert script. But if the Oracle table is never modified via Oracle, you could just drop the table and re-run the INSERT.
Steve Bollinger (3 years ago)
poor visual quality

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.