17,377
社区成员
发帖
与我相关
我的任务
分享
1,2,3,4,5,6,7,8,2012-01-01 12:00:00.00,1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2
SQL> host sqlldr scott/tiger control='c:\append.ctl';
SQL*Loader: Release 10.2.0.1.0 - Production on 星期三 2月 22 09:27:32 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
达到提交点 - 逻辑记录计数 1
SQL> select * from DEFINE_GROUP_SET;
GROUPT GROUPCODE GROUPNAME
G
------ ------------------------------ ------------------------------------------
------------------ -
D
-
NOTE
--------------------------------------------------------------------------------
--------------------
ID CREATOR_ID CREATE_TIME COSTCENTERCODE
------------------------------------ ---------- -------------- -----------------
-------------
BUSINESSTYPECODE P TABLECOLUMN
------------------------------ - ----------------------------------------
PARMA02
--------------------------------------------------------------------------------
--------------------
PARMA03
--------------------------------------------------------------------------------
--------------------
PARAM04 P GROUPTABLE
---------------------------------------- - -------------------------------------
---
USERTABLE RPTC R R
---------------------------------------- ---- - -
SUBWHERE
--------------------------------------------------------------------------------
--------------------
R GROUPROOTCODE REALCOLUMNNAME01
- ------------------------------ -----------------------------------------------
---
REALCOLUMNNAME02
--------------------------------------------------
REALCOLUMNNAME03
--------------------------------------------------
REALCOLUMNNAME04
--------------------------------------------------
REALCOLUMNNAME05
--------------------------------------------------
REALCOLUMNCODE01
--------------------------------------------------
REALCOLUMNCODE02
--------------------------------------------------
REALCOLUMNCODE03
--------------------------------------------------
REALCOLUMNCODE04
--------------------------------------------------
REALCOLUMNCODE05
--------------------------------------------------
BUDGETCOLUMNNAME01
--------------------------------------------------
BUDGETCOLUMNNAME02
--------------------------------------------------
BUDGETCOLUMNNAME03
--------------------------------------------------
BUDGETCOLUMNNAME04
--------------------------------------------------
BUDGETCOLUMNNAME05
--------------------------------------------------
BUDGETCOLUMNCODE01
--------------------------------------------------
BUDGETCOLUMNCODE02
--------------------------------------------------
BUDGETCOLUMNCODE03
--------------------------------------------------
BUDGETCOLUMNCODE04
--------------------------------------------------
BUDGETCOLUMNCODE05
--------------------------------------------------
ITEMCODE01
--------------------------------------------------
ITEMCODE02
--------------------------------------------------
ITEMCODE03
--------------------------------------------------
ITEMCODE04
--------------------------------------------------
ITEMCODE05 PREFIXCONSTANTCOLUMN01
-------------------------------------------------- -----------------------------
-
INFIXCONSTANTCOLUMN01 SUFFIXCONSTANTCOLUMN01 SUFFIXCONSTANTCOLU
MN02 R D I
------------------------------ ------------------------------ ------------------
------------ - - -
1 2 3
4
5
6
7 8 01-1月 -12 1
1 1 1
1
1
1 1 1
1 2 2 2
2
2 2 2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2 2
2 2 2
2 2 2
SQL>
CREATE TABLE DEFINE_GROUP_SET(
GROUPTYPECODE char (6) null,
GROUPCODE varchar2 (30) null,
GROUPNAME varchar2 (60) NULL);
load data
infile 'f:\123.txt'
insert into table DEFINE_GROUP_SET
fields terminated by ','
(
GROUPTYPECODE,
GROUPCODE,
GROUPNAME
)
000002,0101,产量商品量