var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Loading Fixed length data
I am trying to use SQL Loader to load data from text file that is of fixed length. This is the control file that I use.
INTO TABLE VALID
COMP_PLAN_TITLE POSITION(1:50) VARCHAR,
COMP_RATE POSITION(51:100) VARCHAR,
BONUS_RATE POSITION(101:150) VARCHAR,
IB_SPLIT POSITION(151:200) VARCHAR
When I tried to load, position that I have mentioned is taken in terms of bytes i.e., say Comp_plan_title 50 bytes and so on.
Is there any way that i can explicitly say that it is mere position and not bytes.
Any help would be highly appreciated.
Just an idea ... what happens if you substitute VARCHAR with CHAR in control file? For example,
COMP_PLAN_TITLE POSITION(1:50) CHAR
It worked !!!. Thanks for the suggestion.