| I really need your help .please help me (sqlloader poblem) [message #129711] |
Tue, 26 July 2005 06:13  |
koolivand
Messages: 1
Registered: July 2005
|
Junior Member |
|
|
Hi everybody
I am a beginner in SQL *LOADER. My data file is below and i want to generate control file to separate object's field and import to my table.
I really need your help .
Datafile:
---------------------------------------------------------------
AB CDR MsCallSMSinSC={
sequenceNumber=241582451
callType=0
registerTime=2005-07-21 00:01:16
sendOutTime=2005-07-21 00:01:16
callingNumber=989191120000
calledNumber=989191220000
languageType=0
messageReference=608502576
messageCause=0
messageLength=51
protocolID=0
serviceType=0
exchangedIdentity=ZTEMSC
}
AB CDR MsCallSMSinSC={
sequenceNumber=241582452
callType=0
registerTime=2005-07-21 00:01:16
sendOutTime=2005-07-21 00:01:16
callingNumber=989191220000
calledNumber=989192220000
languageType=0
messageReference=608502584
messageCause=0
messageLength=40
protocolID=0
serviceType=0
exchangedIdentity=ZTEMSC
}
AB CDR MsCallSMSinSC={
sequenceNumber=241582453
callType=0
registerTime=2005-07-21 00:01:16
sendOutTime=2005-07-21 00:01:16
callingNumber=989192220000
calledNumber=989192120000
languageType=0
messageReference=608502592
messageCause=0
messageLength=160
protocolID=0
serviceType=0
exchangedIdentity=ZTEMSC
}
AB CDR MsCallSMSinSC={
sequenceNumber=241613269
callType=0
registerTime=2005-07-21 00:04:14
sendOutTime=2005-07-21 00:04:14
callingNumber=989192120000
calledNumber=989192320000
languageType=0
messageReference=732116937
messageCause=0
messageLength=149
messageIsReceipt(message is receipt)
protocolID=0
serviceType=0
exchangedIdentity=ZTEMSC
}
AB CDR MsCallSMSinSC={
sequenceNumber=241613303
callType=0
registerTime=2005-07-21 00:04:15
sendOutTime=2005-07-21 00:04:15
callingNumber=989192320000
calledNumber=989192120000
languageType=0
messageReference=732117057
messageCause=0
messageLength=140
protocolID=0
serviceType=0
exchangedIdentity=ZTEMSC
}
AB CDR MsCallSMSinSC={
sequenceNumber=241613304
callType=0
registerTime=2005-07-21 00:04:15
sendOutTime=2005-07-21 00:04:15
callingNumber=989192120000
calledNumber=989192140000
languageType=0
messageReference=732117065
messageCause=0
messageLength=116
messageIsReceipt(message is receipt)
protocolID=0
serviceType=0
exchangedIdentity=ZTEMSC
}
------------------------------------------------------------------
Table structure:
Create Table test(
Col1 varchar(50),
Col2 varchar(50),
Col3 varchar(50),
Col4 varchar(50),
Col5 varchar(50),
Col6 varchar(50),
Col7 varchar(50),
Col8 varchar(50),
Col9 varchar(50),
Col10 varchar(50),
Col11 varchar(50),
Col12 varchar(50),
Col13 varchar(50),
);
------------------------------------------------------------
Thank you in advance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
