SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql Loader or External Table ?

muttleychessJul 3 2007 — edited Jul 4 2007

HI

I must to export data in Text file to Table

'01301271000140';'KIT01';2;'02'
'01301955000141';'KIT01';1;'02'
'01303150000137';'KIT01';1;'02'
'01303606000169';'KIT01';1;'02'
'01303846000163';'KIT01';1;'02'
'01304517000137';'KIT01';1;'02'
'01305201000160';'KIT01';1;'02'
'01305395000101';'KIT01';2;'02'
'01305410000103';'KIT01';1;'02'
'01305551000126';'KIT01';2;'02'
'01306269000163';'KIT01';1;'02'
'01306734000166';'KIT01';1;'02'
'01309219000130';'KIT01';2;'02'
'01310023000165';'KIT01';4;'02'
'01310450000143';'KIT01';1;'02'
'01311819000132';'KIT01';1;'02'
'01311957000111';'KIT01';1;'02'
'01312870000169';'KIT01';1;'02'
'01312932000132';'KIT01';2;'02'
'01312996000133';'KIT01';1;'02'

36821 rows selected
Stopped spooling to C:\TMP\INS_LTR.DAT

I Want to learn to use External Tables, How can I to do ? and How can I to use Sql Loader
Somebody have a example ?

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2007

Added on Jul 3 2007

10 comments

1,715 views