Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail From: "Anurag Varma" Newsgroups: comp.databases.oracle.server Subject: Re: Char String printing Order Date: 6 Jun 2005 10:10:46 -0700 Organization: http://groups.google.com Lines: 14 Message-ID: <1118077846.218484.28810@g14g2000cwa.googlegroups.com> References: <1118060289.272545.248560@o13g2000cwo.googlegroups.com> NNTP-Posting-Host: 13.8.125.11 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1118077851 8912 127.0.0.1 (6 Jun 2005 17:10:51 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 6 Jun 2005 17:10:51 +0000 (UTC) In-Reply-To: <1118060289.272545.248560@o13g2000cwo.googlegroups.com> User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: g14g2000cwa.googlegroups.com; posting-host=13.8.125.11; posting-account=Bjij0w0AAACWMZ9jVkCMjBKLT0Yf1PAH Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244350 Try: ORA10G> select regexp_replace('ORACLE','(.)','\1'||chr(10)) from dual 2 / REGEXP_REPLACE('ORACLE','(.)','\1'|| ------------------------------------ O R A C L E