convert a negative number into one with a trailing "minus sign,"

   
SQL>
SQL> SELECT
  2     TO_CHAR(-1234,'9999MI') result
  3  FROM dual;

RESUL
-----
1234-

SQL>

1.	The TO_CHAR() function converts the expression into character data.
2.	Pass variable into to_char function
3.	Use to_char function to init an text value
4.	to_char(bdate,'fmMonth ddth, yyyy')
5.	to_char(round(sqrt(sal),2),'9999.99')
6.	to_char(sysdate, 'Day', 'nls_date_language=Dutch')
7.	to_char(sysdate,'DAY dy Dy') as day, to_char(sysdate,'MONTH mon') as month
8.	to_char(sysdate,'hh24:mi:ss') as time
9.	CONVERSION functions: Print the current date/time as a character string and modifies the format

convert a negative number into one with a trailing "minus sign," : TO_CHAR « Conversion Functions « Oracle PL / SQL