RE: sqlplus formatting question

From: William Rogge <William_Rogge_at_voltek.com>
Date: Mon, 06 Aug 2001 06:26:24 -0700
Message-ID: <F001.00361511.20010806061120@fatcity.com>

Use the translate function:

select translate('abc def ghi jkl',' ','_') test from dual;

TEST

abc_def_ghi_jkl

I think this is what you want.

-----Original Message-----
From: John Dunn [SMTP:john.dunn_at_sefas.co.uk] Sent: Monday, August 06, 2001 8:36 AM

To:     Multiple recipients of list ORACLE-L
Subject:        sqlplus formatting question

I want to display a varchar2 field that contains spaces between words i.e MY NAME, but replace the spaces with underscores on the report i.e MY_NAME

How can I do this in sqlplus?

John

--

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

Author: John Dunn
INET: john.dunn_at_sefas.co.uk

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: William Rogge
INET: William_Rogge_at_voltek.com

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