Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extract the table data in Fixed width file

user1758353Nov 4 2011 — edited Nov 7 2011
Hi All,

I would like to extract the table data in fixed width file. I have tried to extract from Toad but it didn't work.

My requirment is the below

Empno length(1-10) Data type number
Ename length(11-30) Data type String
Deptno length(31-40) Data type Number

I have tried using RPAD and it didn't work.

Appreciate your help on this.

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2011
Added on Nov 4 2011
15 comments
7,416 views