-
loading default value via sql loader
1) my flat file is like such.
id t2_id t_date
1902004-09-13
2952004-09-15
2) table
my_tab
---------------
id numbber
t2_id number
t_date date
created_by number
created_date date
3) i would like to load flat file
while defaulting create_by to 1
and created_date to to_date(20040914,'yyyymmdd')
4) i would like to do something like this(whic doesn't work):
load data
infile '/tmp/flat_file.txt"str X'02'"
append
into table my_tab
fields TERMINATED BY X'01'
trailing nullcols(
id,
t2_id,
t_date,
created_by default 1,
created_date default to_date(20040914,'yyyymmdd'))
thanks
-
never mind. something like this works. the constant keyword filled in the defaults.
infile '/u02/data/emusic/EMUSIC.song_dl_history.00.txt' "str X'02'"
truncate
into table songs
fields TERMINATED BY X'01'
trailing nullcols(
USER_ID,
SONG_ID,
DATE_DOWNLOADED date "yyyy-mm-dd" nullif date_downloaded="0000-00-00",
RIGHT_ID filler,
album_id filler,
created_by constant 1,
created_date sysdate,
updated_by constant 1,
updated_date sysdate)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|