Home arrow Oracle arrow Page 4 - Loading Spread Sheet Data into Oracle 10G XE

Continuing to Load - Oracle

If you have ever loaded data into an Oracle table, you know that it is a rather complicated process. You will be surprised at how much easier it is to do in Oracle 10G XE. Keep reading to find out.

TABLE OF CONTENTS:
  1. Loading Spread Sheet Data into Oracle 10G XE
  2. Loading the XLS file into Oracle
  3. Loading the Spread Sheet into Oracle XE
  4. Continuing to Load
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 29
July 26, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

If you were to start afresh and come to the stage where you can make changes to the data you will see this screen. Here for the two columns with the data type date, you can pull down on the drop-down and change them to type Date.

If you now continue to load you will end up with 9 failures and 0 successes as shown in the next picture. The reason for this is that the date format mm/dd/yy is not acceptable to Oracle 10G XE.

 

 

Now if you click on the hyperlink in the Failed column in the next table pertaining to this load, TestNW2, you will see the following screen displayed. This shows why the failure occurred (Ora 01843: not a valid month).

 

Now if you make the following changes while loading you will see that the loading was a success for this loading, TestNW4.

 

You may click on the table name TestNW4 and verify that the data type for the two columns with the date data type came out okay.

Summary

Loading an MS Excel file into Oracle 10G XE was a very simple exercise. It required no more than cutting and pasting the data. The interface is simple, intuitive and the loading process is well staged. It would have been helpful if some interactive help were available for data formatting. The reporting of loading success and failure is immediately available without opening another file, making the process very simple and effortless. Oracle 10G XE is really a one-stop solution for data management and application development that would appeal to many.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: