Saturday, August 9, 2008

SQL LOADER Tutorial

SQL LOADER Tutorial:-
--------------------------

Introduction of SQL LOADER

Variable record format

Fixed record format

Demo Fixed Script

Demo Variable Script

Question and Answers
at

1 comment:

  1. phaniJuly 14, 2009 at 9:18 PM

    Hi Friends,
    The below command we used in control file to load the degree symbol of data file to staging table.

    If you don’t use the below replace command, degree symbol will be stored in staging table as some other special symbol.





    CONDITIONS_SHIP "replace(:CONDITIONS_SHIP,'°',chr(176))",

    Thank you SivaPrasad Amudala for sharing this.

    Regards

    Phani

    ReplyDelete