SQL*Loader for Insert.

How can I build do an SQL* Loader to do an insert in the TBRECEIPTS table.



 RC_PAYMNB number(10)  RC_CASHNB Number(8) RC_DATE Varchar2(19)
 ----------                         ----------                            -------------------
 42884297                         888888                             10-10-2004

 RC_DATA Vachar2(2500)
 -------
     T S T T        

IND.SQUARE/EDWARD ST

VAT REG# 100476     

Bill Payment  2004/07/1            1.00

Account:   91013698-0000                

      Chantal Rigaud                    

A/c Balance:  2,534.33                  

                                       

                                       

TOTAL                              1.00

                                       

TENDERED                                

 Cash                     1.00          

    TOTAL TENDERED                 1.00

                                       

CHANGE                             0.00

                                       

Payment No:   42884297 Cashier:  888888

           18-Oct-2004 09:12            

IF YOU NEED TO KNOW 

HOW MUCH YOU OWE !  

CALL 800-BILL (2455)
















mathieu_cuprykAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pratikroyCommented:
Is your datafile a fixed length/delimited file ?
0
mathieu_cuprykAuthor Commented:
I do not have a data file. I just did a select. I cannot do an insert with RC_DATA field because of <CR> or the square boxes
0
mathieu_cuprykAuthor Commented:
SP2-0734: unknown command beginning "IND.SQUAR..." - rest of line ignored.
SP2-0734: unknown command beginning "VAT REG# ..." - rest of line ignored.
SP2-0734: unknown command beginning "Bill Payme..." - rest of line ignored.
SP2-0734: unknown command beginning "Account:  ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "Chantal Ri..." - rest of line ignored.
  1* insert into TBRECEIPTS (RC_PAYMNB, RC_CASHNB, RC_DATE, RC_DATA) VALUES (42884297,888888,'10-10-2004',      T S T T        /c Balance:  2,534.33
SP2-0734: unknown command beginning "TOTAL     ..." - rest of line ignored.
SP2-0042: unknown command "TENDERED" - rest of line ignored.
SP2-0734: unknown command beginning "Cash      ..." - rest of line ignored.
SP2-0734: unknown command beginning "TOTAL TEND..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
  1* insert into TBRECEIPTS (RC_PAYMNB, RC_CASHNB, RC_DATE, RC_DATA) VALUES (42884297,888888,'10-10-2004',      T S T T        /c Balance:  2,53433
SP2-0734: unknown command beginning "Payment No..." - rest of line ignored.
SP2-0734: unknown command beginning "18-Oct-200..." - rest of line ignored.
SP2-0734: unknown command beginning "IF YOU NE..." - rest of line ignored.
SP2-0734: unknown command beginning "HOW MUCH ..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "CALL 800-..." - rest of line ignored.
SP2-0042: unknown command "" - rest of line ignored.
SP2-0042: unknown command "')" - rest of line ignored.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

mathieu_cuprykAuthor Commented:
insert into TBRECEIPTS (RC_PAYMNB, RC_CASHNB, RC_DATE, RC_DATA) VALUES (42884297,888888,'10-10-2004',      T S T T        

IND.SQUARE/EDWARD ST

VAT REG# 100476     

Bill Payment  2004/07/1            1.00

Account:   91013698-0000                

      Chantal Rigaud                    

A/c Balance:  2,534.33                  

                                       

                                       

TOTAL                              1.00

                                       

TENDERED                                

 Cash                     1.00          

    TOTAL TENDERED                 1.00

                                       

CHANGE                             0.00

                                       

Payment No:   42884297 Cashier:  888888

           18-Oct-2004 09:12            

IF YOU NEED TO KNOW 

HOW MUCH YOU OWE !  

CALL 800-BILL (2455)
















');
0
mathieu_cuprykAuthor Commented:
insert into TBRECEIPTS (RC_PAYMNB, RC_CASHNB, RC_DATE, RC_DATA) VALUES (42884297,888888,'10-10-2004', '     T S T T        

IND.SQUARE/EDWARD ST

VAT REG# 100476     

Bill Payment  2004/07/1            1.00

Account:   91013698-0000                

      Chantal Rigaud                    

A/c Balance:  2,534.33                  

                                       

                                       

TOTAL                              1.00

                                       

TENDERED                                

 Cash                     1.00          

    TOTAL TENDERED                 1.00

                                       

CHANGE                             0.00

                                       

Payment No:   42884297 Cashier:  888888

           18-Oct-2004 09:12            

IF YOU NEED TO KNOW 

HOW MUCH YOU OWE !  

CALL 800-BILL (2455)
















');
0
mathieu_cuprykAuthor Commented:
T S T T        \n\nIND.SQUARE/EDWARD ST\n\nVAT REG# 100476     \n\nBill Payment  2004/07/1          100.00 \n\nAccount:   91013698-0000                \n\n      Chantal Rigaud                    \n\nA/c Balance:  2,566.33                  \n\n                                        \n\n                                        \n\nTOTAL                            100.00 \n\n                                        \n\nTENDERED                                \n\n Cash                   100.00          \n\n    TOTAL TENDERED               100.00 \n\n                                        \n\nCHANGE                             0.00 \n\n
Answered my own question.
0
hanzpkCommented:
well, if still want the sqlloader answer...
below is the control file, and invoke something like = sqlldr user/password@db control=thisfile.ctl

control file
========
LOAD DATA
INFILE *
APPEND
INTO TABLE tbreceipts
FIELDS TERMINATED BY "@" OPTIONALLY ENCLOSED BY '"'
   (RC_PAYMNB,RC_CASHNB,RC_DATE, RC_DATA )
   BEGINDATA
42884297@888888@"10-10-2004"@     T S T T        

IND.SQUARE/EDWARD ST

VAT REG# 100476     

Bill Payment  2004/07/1            1.00

Account:   91013698-0000                

      Chantal Rigaud                    

A/c Balance:  2,534.33                  

                                       

                                       

TOTAL                              1.00

                                       

TENDERED                                

 Cash                     1.00          

    TOTAL TENDERED                 1.00

                                       

CHANGE                             0.00

                                       

Payment No:   42884297 Cashier:  888888

           18-Oct-2004 09:12            

IF YOU NEED TO KNOW 

HOW MUCH YOU OWE !  

CALL 800-BILL (2455)















0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mathieu_cuprykAuthor Commented:
Instead of using the square boxes I used \n
This I will try thanks. Looks good.:-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.