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

Home -> Community -> Mailing Lists -> Oracle-L -> sql or plsql format output

sql or plsql format output

From: raja rao <raja4list_at_yahoo.com>
Date: Fri, 19 May 2006 08:47:21 -0700 (PDT)
Message-ID: <20060519154721.86624.qmail@web31402.mail.mud.yahoo.com>


Hi Team,
  Can some one help me in producing the below output format.    

  table emp:    

  myno    myname   unitcount    unit      unitcode
1       xyz              4               100      12345
   

  all the fomrat should be presented like:   

if the unitcount >0
then
 do a unitcount-1 (now unitcount=3)
then that many times the 4th and 5th cols should be printed.   

shold be like this:

  myno    myname   unitcount     unit  unitcode
1       xyz      3      100             12345
                            100             12345
                            100             12345
  

i tried a lot with plsql. tried to use shell commands to generate the output into 2 files and tried to do a paste but lot of inconsistency.    

  Could someone help me ?    

  Thanks in advance,
Raj                 



Blab-away for as little as 1/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice.
--

http://www.freelists.org/webpage/oracle-l Received on Fri May 19 2006 - 10:47:21 CDT

Original text of this message

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