Demo fixed script

Demo Fixed script:-
----------------------

It is always good to run some script successfully and tries to learn more about it, features etc. This page is design for the SQL*LOADER scripts for the Fixed format data-file.

Follow the steps given below to run the fixed format data-file script.

1) Create one Folder in your Operating System. Let the folder name ‘XYZ’

2) Download the Data-File in the XYZ folder.

Click on the link given to download the Data-File: Click Here

3) Download the CONTROL in the XYZ folder.

Click on the Link given to download the CONTROL file: Click Here

4) Download the CREATE Table script in the XYZ Folder.

Click on the Link given to Download the create table script: Click Here

5) Execute/Run the Create Table script in your database to create the table.

6) Run the command to run the Control file.

sqlldr USERID=scott/tiger CONTROL=aottest.ctl

7) Verify the log file created and also check if there is any bad or discard file created.

8) Query the table in database where you have INSERTED the records.

PREVIOUS                                    SQLLOADER-HOME                               NEXT