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!

Create flat file.txt with specified width

Shadow123Sep 15 2016 — edited Sep 16 2016

Hi Gurus

I really appreciate if some one help me out , I want to create flat file with txt extension by using oracle table. I'm wondering that I can achieve this task by using SQL Developer and few SQL Plus commands but the problem is that I want to create this flat column with some specified columns width.

For example :. If I have scott.emp table then I want to create this flat with the following width:

Empno 10

Ename 60

Job 30

-------------------

I case if any column value is null then system don't care about it and assign the column specified width. for example if we have job column value is null then system still assign width 30. Can somebody help me out. Thanks in advance......

This post has been answered by John Spencer on Sep 16 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2016

Added on Sep 15 2016

20 comments

3,046 views