Re: How to format a column from code.

From: HansF <News.Hans_at_telus.net>
Date: Wed, 24 Aug 2005 20:05:47 GMT
Message-Id: <pan.2005.08.24.20.09.55.66204@telus.net>

On Wed, 24 Aug 2005 12:31:18 -0700, Chuck interested us by writing:

>
> With sqlplus I can do "COL mycol FORMAT 999,999,999" to format long
> numbers with commas.
>
> How can I do this from within code? Do I need to just select the column
> and then use logic in the code to reformat the numbers?

That's one way, yes. The best? Possibly not ... two Oracle documentation manuals (from http://docs.oracle.com) to your rescue:

"Oracle SQL Language Reference Manual" and look up the functions that can be used to do formatting.

"Oracle Database Application Developer Manual - Fundementals" to help you understand how to code in an Oracle environment.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Wed Aug 24 2005 - 15:05:47 CDT