Oracle: Pattern for to_char(number) to add additional ascii characters?

oracle formatting numbers ascii oracle-apex
fdl picture fdl · Feb 25, 2009 · Viewed 28.3k times · Source

Using the Oracle to_char(number) function, is it possible to append ascii characters to the returned string?

Specifically, I need to add a percentage character to the returned string.

"select to_char(89.2244, '999G999G999G999G990D00') from dual" --> returns "89.22". I need a format pattern that returns "89.22%".

I am using this through reports in Application Express, so cannot simply concatenate "%" to the query, i need to put it in the number format.

Answer

Barry picture Barry · Feb 25, 2009

So you can't wrap the to_char with a CONCAT?

select concat(to_char(89.2244, '999G999G999G999G990D00'),'%') from dual

Related questions

Remove leading spaces and the SQL> tags when spooling

I m doing an export using SQL*Plus using the following code: Set echo off Set verify off Set feedback off Set heading off Set termout on Set pages 50000 Set linesize 1000 Set newpage none Set colsep "," spool Z:\ff\ss.…

Read More
To_Char and T_Number alternate in SQL Server for formatting

What is the SQL Server alternate of To_CHAR([Column_Name], -987654321) To_Number([Column_Name],'999999999D99999900') ? Also, What I can predict from the syntax is that they both are being used for formatting. Then what is the …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More