OraFAQ Forum: Forms » how to arrange fields in my text output

Home » Developer & Programmer » Forms » how to arrange fields in my text output

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to arrange fields in my text output [message #116059]

Sun, 17 April 2005 03:39

zigbinputi
Messages: 11
Registered: April 2005

Junior Member

hi,

im generating a txt file. my problem is how to arrange
the output of my txt file. attached is a sample output i want to make.

my problm now is how to position the (txt)fields (ie SSn, Bdate, Lname, etc..).like in C we can use gotoxy to position these fields. how can we do this in oracle? this there a reserved word like gotoxy?

pls help...

thnks..

Attachment: output.txt
(Size: 0.54KB, Downloaded 1205 times)

[Updated on: Sun, 17 April 2005 03:52]

Report message to a moderator

Re: how to arrange fields in my text output [message #116119 is a reply to message #116059]

Sun, 17 April 2005 21:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Write it in SQL*Plus using the column facility.

This is not a Forms question.

[Updated on: Mon, 18 April 2005 18:58]

Report message to a moderator

Re: how to arrange fields in my text output [message #116163 is a reply to message #116119]

Mon, 18 April 2005 06:50

zigbinputi
Messages: 11
Registered: April 2005

Junior Member

im using forms6i in generating the txt.

Report message to a moderator

Re: how to arrange fields in my text output [message #116256 is a reply to message #116059]

Mon, 18 April 2005 18:59

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Okay ... use 'rpad' on character fields to get the width and 'to_char' with a full width format on numeric fields.

Report message to a moderator

Re: how to arrange fields in my text output [message #116483 is a reply to message #116256]

Wed, 20 April 2005 06:02

zigbinputi
Messages: 11
Registered: April 2005

Junior Member

thanks a lot...it works..

Report message to a moderator

Previous Topic:	duplocate detail
Next Topic:	LOV

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:59:39 CDT 2024