RE: RPAD problem

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Tue, 15 Jan 2002 11:29:55 -0800
Message-ID: <F001.003F0596.20020115104033@fatcity.com>

If they have a null value in place of the SSN field, you can use NVL for this and pad with one blank. Also, check to make sure that the field is not VARCHAR2. If it is, blanks are chopped...

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: Stephen.Karniotis_at_Compuware.com
Web: www.compuware.com

 -----Original Message-----
Sent: Tuesday, January 15, 2002 12:17 PM

To:     Multiple recipients of list ORACLE-L
Subject:        RPAD problem

I am trying to create fixed length records from Oracle variable length data.

I have the command RPAD(A.SSN,9) in the select statement of a query. If the person has '' in the SSN field, RPAD does not pad it out to 9 spaces.

Is there aother way to do this?

Thanks,
Rod
--

Rod Clayton KA3BHY
Systems Programmer
Howard County Public Schools
rclayton_at_mail.howard.k12.md.us
--

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

Author: Rod Clayton
  INET: rclayton_at_mail.howard.k12.md.us

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

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

Author: Karniotis, Stephen
  INET: Stephen_Karniotis_at_compuware.com

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 Tue Jan 15 2002 - 13:29:55 CST