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

2 comments:

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

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, OAF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.