Pass variable into to_char function : TO_CHAR « Conversion Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Conversion Functions
  3. TO_CHAR

Pass variable into to_char function

   
SQL> DECLARE
  2     lv_format_txt  CONSTANT VARCHAR2(11) := '$99,999.99';
  3     lv_test_txt             VARCHAR2(11);
  4     lv_test_num             NUMBER := 54321;
  5  BEGIN
  6     lv_test_txt := TO_CHAR(lv_test_num, lv_format_txt);
  7     DBMS_OUTPUT.PUT_LINE('Test Value: ' || lv_test_txt);
  8  END;
  9  /
Test Value:  $54,321.00

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>








Related examples in the same category

1.The TO_CHAR() function converts the expression into character data.
2.Use to_char function to init an text value
3.convert a negative number into one with a trailing "minus sign,"
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