Database Utilities (MOSC)

MOSC Banner

upload data using sqlldr by conditinig

edited Dec 27, 2010 4:59PM in Database Utilities (MOSC) 20 commentsAnswered
 hi guru,

I need to upload data to oracle DB by using sqlldr.  but need to uplaod col1 values =15.  secondly need to add to oracle name of the txxt file with eash record.

data to be uploaded in oracle. table structure
 
create table CDR(
col1 number(4),
col2  number(20),
col3 number(10),
col4 number(2),
col5 number(10),
col6 number(10),
col7 number(20),
col8 date,
col9 number(20),
col10 char(20))


create table CDR_DUP(
col1 number(4),
col2  number(20),
col3 number(10),
col4 number(2),
col5 number(10),
col6 number(10),
col7 number(20),
col8 date,
col9 number(20),
col10 char(20))


data receive to upload to oracle in text format
name of the file.20101207media_cdr_12

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center