Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Formatting Ouput - Select Statement

Formatting Ouput - Select Statement

From: Jennmar Corp <here_at_work.com>
Date: Fri, 6 Apr 2001 11:45:03 -0400
Message-ID: <tcrp3ct86gb6ea@corp.supernews.com>

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...

Output
12345..123..Next Element

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US