RE: simple sql problem

From: Pulikkol Kumar <pullikol.kumar_at_mannai.com.qa>
Date: Tue, 31 Jul 2001 22:50:16 -0700
Message-ID: <F001.0035B6C7.20010731224058@fatcity.com>

 This will work out ................

SELECT  DECODE(SIGN(x+y-1) , 1,LPAD(TO_CHAR(x+y),LENGTH(x+y),'0'),
                               LPAD(TO_CHAR(x+y),LENGTH(x+y)+1,'0'))  FROM
blah
                                                                                       
               
                                                                                       
               
                                                                                       
               
    Pulikkol Nitheesh Kumar                                                            
               
                                                                                       
               
    Software Engineer                                                                  
               
                                                                                       
               
    Mannai Corporation                                                                 
               
                                                                                       
               
                                C O S - PB # 76                                        
               
                                                                                       
               
                                Doha - Qatar                                           
               
                                                                                       
               
                                Phone : 4412-555 extn                                  
               
                                -363                                                   
               
                                                                                       
               
                                http//www.mannai.com.qa

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Pulikkol Kumar
INET: pullikol.kumar_at_mannai.com.qa

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 01 2001 - 00:50:16 CDT