Script to create the SQLLDR control file from Oracle table.

Shell Programming and Scripting
1

I need to create the shell script load the few 100 table using the SQLLDR.

Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.

example table rows below

table_nme column_nme
DEPT DEPTNO
DEPT DNAME
DEPT LOC
EMP EMPNO
EMP ENAME
EMP SAL

..Etc..has more the few 100 tables.

2

Can you post what you've done to solve this...

3

... and show us the output you want to produce from the sample input you provided?