OraFAQ Forum: Server Utilities » Passing the data filename parameter in my table?

Home » RDBMS Server » Server Utilities » Passing the data filename parameter in my table?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Passing the data filename parameter in my table? [message #72182]

Fri, 04 April 2003 10:48

Sabrina
Messages: 76
Registered: February 2002

Member

My table looks like,

SQL> desc ddd_Data_in;
Name Null? Type
------------------------------- -------- ----
CRN NUMBER(13)
SSN VARCHAR2(9)
DDD_BATCH NUMBER(14)
PRIM_DIAG VARCHAR2(5)
FILENAME VARCHAR(25)

I am loading data in this table through 4 different data(.DAT) files.

My control file looks like,

LOAD DATA
INFILE 'ABC.dat'
INFILE 'ABC1.dat'
INFILE 'ABC2.dat'
INFILE 'ABC3.dat'
into table ddd_data_in append
(
CRN,
SSN,
DDD_BATCH,
PRIM_DIAGNOSIS
)

What i want to do is, in my FILENAME column in my table, i want to pass the data file name i.e. ABC, if that data came in from the file ABC, ABC1, if that data came in from the file ABC1, so on and so forth..

Also do i have to make changes to my .log file?

How do i do that?

Thank you..

Report message to a moderator

Previous Topic:	import/export data to /from a assigned database
Next Topic:	Is there any command similar to SQLSERVER TOP command in Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 29 05:44:06 CDT 2024