2008年
-
编辑 删除
HPUX简体中文系统环境使用手册
http://docs.hp.com/zh_cn/5187-4190/index.html[@more@]
-
编辑 删除
使用oracle外部表
1 、创建目录及授权create directory exttab as 'c:'GRANT READ ON DIRECTORY exttab TO test; GRANT WRITE ON DIRECTORY exttab TO test; 2、存放数据文件test.txt3、创建外部表CREATE TABLE test(name CHAR(31),age number)ORGANIZATION EXTERNAL(TYPE ORACLE_LOADERDEFAULT DIRECTORY exttabACCESS PARAMETERS(RECORDS DELIMITED BY NEWLINEFIELDS TERMINATED BY ',')LOCATION('test.txt'))4、校验外部表select * from test [@more@]
