把以下的不规则文本导入oracle数据库的最好!方法,我的分不够了,改天我一定酬谢400分及其以上!(20分)

G

gcysa

Unregistered / Unconfirmed
GUEST, unregistred user!
我要导入的文本段的开始标志如下,其中07403十分重要,它是与其它文本段的开始标志相区别的唯一特征:

 >$
RUNXUN_SSP 2002-10-15 11:30:35 TU
PW0001 0130/002C/0003
SEQ=7022+2002-10-15 07403 ASKTROCH LCARAA01 HSRRIF41
SWA-ADL SOFTWARE

我所需要的文本段的结束标志如下,07403也是与其他文本段结束标志相区别的唯一特征:

REPORT FOLLOWS 07403

我所要求把以下数据形成字段:

“ DATE OF ISSUE : 2002-OCT-15”形成date字段;
“ RECORD PERIOD : 9H 30M - 12H 30M”形成统计预设时间字段;
“ OUTPUT PERIOD : 10H 30M - 11H 30M”形成统计时间字段;
“ RESULTS LIST : I N C O M I N G”形成出入标志字段;
再下面的那个表格每一列形成一个字段,同时要求把所有字段放入同一个表中。

不规则文本的内容的一部分如下:
 >LON D:/HYCON74/CN1015.LOG
 >$
RUNXUN_SSP 2002-10-15 09:10:30 TU
PW0002 0130/002C/0003
SEQ=7007.2002-10-14 00134 ASKTROCH LCARAA01 HSRRIF41
SWA-ADL SOFTWARE

ACTIVATE-TKG-REPORT SUCCESSFUL
FINAL RESULT 0001 -
-------------------------------------------------------------------------
ADL OPERATING SYSTEM REPORTS :-NORMAL END-:
LAST EXECUTION TIME IS REACHED
AOS INTERNAL NBR = 30

LAST REPORT 00134

RUNXUN_SSP 2002-10-15 09:10:31 TU
PW0001 0130/002C/0003
SEQ=6955.2002-10-11 00134 ASKTROCH LCARAA01 HSRRIF41
SWA-ADL SOFTWARE

ACTIVATE-TKG-REPORT SUCCESSFUL
FINAL RESULT 0001 -
-------------------------------------------------------------------------
ADL OPERATING SYSTEM REPORTS :-NORMAL END-:
LAST EXECUTION TIME IS REACHED
AOS INTERNAL NBR = 30

LAST REPORT 00134

 >$
RUNXUN_SSP 2002-10-15 09:30:00 TU
PW0001 0130/002C/0003
SEQ=7022+2002-10-15 07404 ASKTROCH LCARAA01 HSRRIF41
SWA-ADL SOFTWARE

ACTIVATE-TKG-REPORT SUCCESSFUL
RESULT PART 0001 -
-------------------------------------------------------------------------
TRUNKGROUP REPORT I N P U T R E F L E C T I O N
IDENTITY = 7022-2002-10-15
DATE OF ISSUE = 2002-10-15 09:30
----------------------------------------------------------------------
LET : 2100-01-01 00:00
JCROUT : 134
OUTSET : 1
RECPERD : 09:30-12:30
OUTPERD : 01:00
RECDATE :
10 & 15

REPORT FOLLOWS 07404

 >$
SESSION ENDED (TIMEOUT) !
 >$
RUNXUN_SSP 2002-10-15 10:30:35 TU
PW0001 0130/002C/0003
SEQ=7022+2002-10-15 07403 ASKTROCH LCARAA01 HSRRIF41
SWA-ADL SOFTWARE

ACTIVATE-TKG-REPORT SUCCESSFUL
RESULT PART 0001 +
-------------------------------------------------------------------------
TRUNKGROUP REPORT R E S U L T S
DATE OF ISSUE : 2002-OCT-15 MSTID =
RECORD PERIOD : 9H 30M - 12H 30M
OUTPUT PERIOD : 9H 30M - 10H 30M
RESULTS LIST : I N C O M I N G OBJECTS 1 : 21
----------------------------------------------------------------------------------------------------------------
TRUNKGROUP ASSGD AVLB SEIZ ANSW OCC CONV-OCC ATT-LOCAL ATT-TRANS ANSW-LOCAL ANSW-TRANS
----------------------------------------------------------------------------------------------------------------
TT_AUT_DMI_DTG 10 7 0 0 0,00 0,00 0 0 0 0
TT_AUT_BER 5 1 0 0 0,00 0,00 0 0 0 0
TT_ACS_DIR 4 0 0 0 0,00 0,00 0 0 0 0
TT_MAN_DMI_DTG 1 1 0 0 0,00 0,00 0 0 0 0
TT_MAN_BER 2 2 0 0 0,00 0,00 0 0 0 0
TT_IBP 1 1 0 0 0,00 0,00 0 0 0 0
TT_MAN_NO_HW 1 1 0 0 0,00 0,00 0 0 0 0
SH_SSP 13 0 0 0 0,00 0,00 0 0 0 0
506_IN 402 402 11325 5036 250,50 149,64 0 1451 0 5036
506_OUT 31 0 0 0 0,00 0,00 0 0 0 0
CRC 494 463 32 17 0,43 0,28 0 32 0 17
CNC 123 123 0 0 0,00 0,00 0 0 0 0
CUC 184 184 0 0 0,00 0,00 0 0 0 0
JT 30 30 0 0 0,00 0,00 0 0 0 0
R2_TEST 30 30 6 5 0,04 0,00 0 0 0 5
ZX_SDWX 30 30 66 34 2,06 1,80 0 66 0 34
ZX_ZL 30 30 0 0 0,00 0,00 0 0 0 0
ZX_ZL2 30 30 116 56 2,51 1,95 0 116 0 56
ZTE_SS7 216 216 0 0 0,00 0,00 0 0 0 0
HARRIS 30 30 38 0 0,81 0,00 0 0 0 0
PRA_ZTE 180 30 0 0 0,00 0,00 0 0 0 0

REPORT FOLLOWS 07403

RUNXUN_SSP 2002-10-15 10:30:35 TU
PW0001 0130/002C/0003
SEQ=7022+2002-10-15 07403 ASKTROCH LCARAA01 HSRRIF41
SWA-ADL SOFTWARE

ACTIVATE-TKG-REPORT SUCCESSFUL
RESULT PART 0002 -
-------------------------------------------------------------------------
TRUNKGROUP REPORT R E S U L T S
DATE OF ISSUE : 2002-OCT-15 MSTID =
RECORD PERIOD : 9H 30M - 12H 30M
OUTPUT PERIOD : 9H 30M - 10H 30M
RESULTS LIST : O U T G O I N G OBJECTS 1 : 21
---------------------------------------------------------------------------------------------------------------------------
TRUNKGROUP ASSGD AVLB SEIZ ANSW OCC CONV-OCC CALL-ATT THRSW RETRIES NO-ANSW CONG-DIST
---------------------------------------------------------------------------------------------------------------------------
TT_AUT_DMI_DTG 10 7 0 0 0,00 0,00 0 0 0 0 0
TT_AUT_BER 5 1 0 0 0,00 0,00 0 0 0 0 0
TT_ACS_DIR 4 0 0 0 0,00 0,00 0 0 0 0 0
TT_MAN_DMI_DTG 1 1 0 0 0,00 0,00 0 0 0 0 0
TT_MAN_BER 2 2 0 0 0,00 0,00 0 0 0 0 0
TT_IBP 1 1 0 0 0,00 0,00 0 0 0 0 0
TT_MAN_NO_HW 1 1 0 0 0,00 0,00 0 0 0 0 0
TT_LER 1 1 0 0 0,00 0,00 0 0 0 0 0
SH_SSP 13 0 0 0 0,00 0,00 0 0 0 0 0
506_IN 402 402 0 0 0,00 0,00 0 0 0 0 0
506_OUT 31 0 0 0 0,00 0,00 0 0 0 0 0
CRC 494 463 3225 1154 39,28 26,97 3229 1527 0 304 19
CNC 123 123 518 286 14,21 12,72 518 346 0 29 0
CUC 184 184 2221 1411 61,85 54,77 2223 1710 0 204 2
JT 30 30 157 79 3,02 2,48 157 97 0 12 9
ZX_SDWX 30 30 0 0 0,00 0,00 0 0 0 0 0
ZX_ZL 30 30 0 0 0,00 0,00 0 0 0 0 0
ZX_ZL2 30 30 0 0 0,00 0,00 0 0 0 0 0
ZTE_SS7 216 216 4309 2243 94,81 77,18 4309 3274 0 703 0
HARRIS 30 30 0 0 0,00 0,00 0 0 0 0 0
PRA_ZTE 180 30 0 0 0,00 0,00 0 0 0 0 0

REPORT FOLLOWS 07403
 
顶部