OraFAQ Forum: Server Administration » Re: How do you create a fixed width file?

Home » RDBMS Server » Server Administration » Re: How do you create a fixed width file?

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

Re: How do you create a fixed width file? [message #370286]

Thu, 29 July 1999 20:45

Amit Chauhan
Messages: 74
Registered: July 1999

Member

You can do so using RPAD and LPAD SQL functions. I don't know the actual syntax right now, but I can give you tomorrow if you want. You can mail me and let me know.

- Amit

Report message to a moderator

Re: How do you create a fixed width file? [message #370287 is a reply to message #370286]

Thu, 29 July 1999 23:46

Anita Flores
Messages: 1
Registered: July 1999

Junior Member

Amit,

Thanks for your quick response. The rpad work very well. I found the syntax:
rpad(column_name,length)||rpad(column_name,length)|| etc.....

Thanks again for your assistance.

Regards,
Anita Flores

Report message to a moderator

Previous Topic:	Multiple Values
Next Topic:	Re: adding new rows only on changes?: proper sql statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 11:03:08 CDT 2025