经常有人问excel报表如何导入到oracle里,toad提供了这个功能,我们来做个简单的实验,一步一步把excel报表导入到oracle里。
一:
先建立个测试的excel报表test.xls(图1)
(图1)
二:在scott用户下建立一test表
[oracle@hundsun ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 6 19:33:52 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
idle> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
idle> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@hundsun ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 6 19:34:21 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
sys@NIUGE> conn scott/tiger
Connected.
scott@NIUGE> create table t(id_no int,id_no1 int,id_no2 int,id_no3 int,id_no4 int,id_no5 int);
create table t(id_no int,id_no1 int,id_no2 int,id_no3 int,id_no4 int,id_no5 int)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
scott@NIUGE> c /t(/test(/
1* create table test(id_no int,id_no1 int,id_no2 int,id_no3 int,id_no4 int,id_no5 int)
scott@NIUGE> r
1* create table test(id_no int,id_no1 int,id_no2 int,id_no3 int,id_no4 int,id_no5 int)
Table created.
scott@NIUGE> select * from test;
no rows selected
|