You are html tracking Visitor

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

1 comment:

phani said...

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