Generate 4 different table structre records into single File
Posted: Tue Sep 13, 2011 12:46 pm
Hi,
I have a requiremnt. I need to merge 2 different table structres into single file with Rec_Types.
Example:
i have 2 source tables in Oracle database.
1. EMP Tables(empno,ename,email,phone..)
2.Dept Table(Empno,dname,Location Col's)
I need to genrate the following sample output format:
Header|empno|ename|manager_id|email|phone
TraILER|empno|dname|location
I have a requiremnt. I need to merge 2 different table structres into single file with Rec_Types.
Example:
i have 2 source tables in Oracle database.
1. EMP Tables(empno,ename,email,phone..)
2.Dept Table(Empno,dname,Location Col's)
I need to genrate the following sample output format:
Header|empno|ename|manager_id|email|phone
TraILER|empno|dname|location