SQL LOADER Tutorial:-
--------------------------
Introduction of SQL LOADER
Variable record format
Fixed record format
Demo Fixed Script
Demo Variable Script
Question and Answers
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
I would like to share some of my design & development work with Oracle Applications community. I will keep adding more information to this page on ongoing basis. My blog will be most useful to those who are new to oracle technology. Do not forget giving your comments. I appreciate your comments or suggestions. This will help making blog best. Learning and Practice Oracle APPS or Oracle Cloud ERP for FREE ---> http://www.grokonline.com/vision-instance/
You are Visitor
Followers (Don't be WILD to WILDLIFE. SAVE TIGERS. Only 1411 left to save.)
Labels
- Download links (1)
- Forms (1)
- Issues and Solution (1)
- IZ0-451 Oracle SOA Foundation Practitioner (1)
- Oracle Applications (1)
- Oracle Training Videos (1)
- PL/SQL Advance (1)
- Ready Scripts (1)
- Release 12 New Features (1)
- SQL LOADER Tutorial (1)
- Unix Commands (1)
- User Guide (1)
- WorkFlow (1)
Blog Archive
-
▼
2008
(121)
-
▼
August
(76)
- AP Module
- Detail Hold information of the Invoice
- Summary Hold information based on the Invoice Number
- Introduction of DYNAMIC SQL
- DBMS_SQL
- EXECUTE IMMEDIATE
- Dynamic SQL
- AP Module 12 Release New Features
- Multiple Organizations Access Control
- Integration with Oracle E-Business Tax
- Integration with Oracle Subledger Accounting
- Payment Configuration Controlled by Global Descrip...
- Integration with Oracle Payments for Funds Disburs...
- Document Sequencing of Payments
- Centralized Banks and Bank Account Definitions in ...
- Invoice Lines
- Suppliers Added to Trading Community Architecture
- Introduction
- Release 12 New Features
- GL Module 12 Release New Features
- Statistical Report-Level Currency for Financial St...
- Revaluation
- Period Rates
- Global Accounting Engine Integration
- Multiple Reporting Currency Changes
- Sets-of-Books Changes
- Accounting Setup
- Changes in Terminology
- OM Module
- Order Line is Invoiced or not
- SQL LOADER Q & A
- Demo fixed script
- Demo Variable script
- Fixed record format
- Variable record format
- SQL LOADER Tutorial
- Introduction of SQL LOADER
- Oracle Application Story
- Know who all users are using the E-Business suite
- Get Report With Parameters list
- Get the user’s status in the ICX_SESSIONS table
- Advance Shipment Notice
- Audit the changes in Profile Options in given numb...
- Get detail of Locks with Object Locked
- P2P Query based on the Purchase Order Number
- PO Module
- Get the Shipment Number based on the po header id ...
- WorkFlow
- Query find Implementation
- PL/SQL Advance
- Oracle Applications Concepts
- Chart of Accounts Structure Overview
- Chart of Account Segment Hierarchy Ranges
- Operating Unit and Legal Entity Configuration
- Summary Account Template definition review script
- Set of Books Configuration Overview
- Segment Value Listing
- Period Status script
- Mass Allocation Formula review script
- Journal Lines With AP Source Reference Fields
- Journal Line Based Trial Balance Report
- Journal Header Summary
- Interface Summary
- Interface Details
- FSG Report and Components Overview
- Flexfield Security Rule Definitions
- Flexfield Security Rule Assignments
- CVR Cross Validation Rule Overview
- CVR Cross Validation Rule Detail Listing
- Code Combinations CCID
- GL Modules
- Ready Scripts
- General/AOL Module scripts
- Balances and Movements
- Autopost Definitions
- ADI Journal Balances
-
▼
August
(76)
Phani profile
- phani
- Hyderabad, AP, India
- Hi, I am Techno-functional Consultant. I got around 8 years experience in Oracle Application and SOA suite.
1 comment:
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
Post a Comment