| urgernt!!! [message #72517] |
Wed, 09 July 2003 23:18  |
Avadbala
Messages: 17
Registered: October 2002
|
Junior Member |
|
|
I have a table like this
a varchar2(5),
a1 varchar2(2),
b varchar2(5),
b1 varchar2(2),
c varchar2(5),
c1 varchar2(2),
dummy varchar2(101)
i am trying to insert data into this table using fixed length format. but the last column in each record is null.. when i try to run the loader.. it gives me column too long error. how do i over come this?
appreciate you help
avad
|
|
|
|
| Re: urgernt!!! [message #72520 is a reply to message #72517] |
Thu, 10 July 2003 12:10  |
Navtej
Messages: 19
Registered: July 2003
|
Junior Member |
|
|
Substr allows you to input a portion of a character string avoiding errors relating to field too long.
.
|
|
|
|
|
|
| Re: urgernt!!! [message #72523 is a reply to message #72517] |
Thu, 10 July 2003 15:22 |
Navtej
Messages: 19
Registered: July 2003
|
Junior Member |
|
|
LOAD DATA
INFILE 'test.ctl'
INSERT INTO TABLE 'TEST'
(a position(1:4) CHAR,
b position(6:16) CHAR,
c position(18:40) CHAR "substr(:c,1,22)
)
desc test
A VARCAHR2(4)
B VARCHAR2(10)
C VARCHAR2(22)
syntax
sqlldr userid=scott/tiger CONTROL=test.ctl
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
