摘要： 将数据从csv中导到ORACLE中。数据库表：CREATE TABLE USERS ( ID VARCHAR2(20), NAME VARCHAR2(20) , SEX VARCHAR2(20), BIRTHDAY DATE )test.csv 文件【数据源】1,包爷,男,"2012-9-10 00:00:00"2,飞哥,男,"2012-4-11 01:00:00"3,"老姚",女,"2012-2-10 02:00:00"result.ctl 控制文件load data infile 'test.csv&# 阅读全文

摘要： 1. 复制表结构及其数据：create table table_name_new as select * from table_name_old2. 只复制表结构：create table table_name_new as select * from table_name_old where 1=2;或者：create table table_name_new like table_name_old3. 只复制表数据：如果两个表结构一样：insert into table_name_newselect * fromtable_name_old如果两个表结构不一样：insert into ta 阅读全文