Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Formatting Ouput - Select Statement
I have to pull information out of the database and format it to fit the standard layout for an upload file.
Example:
Format number len=5 Left Justified A#### filler len=2 Spaces dept len=3 Left Justified A## filler len=2 Spaces etc...
Can I do this within the context of a select statement or is there an easier way to retrieve and then format the output?
select number, dept, etc. from table1 ?
Thanks! Received on Fri Apr 06 2001 - 10:45:03 CDT