OraFAQ Forum: SQL & PL/SQL » Convert number to string

Home » SQL & PL/SQL » SQL & PL/SQL » Convert number to string

Tue, 13 June 2000 15:44

Lee
Messages: 56
Registered: May 1999

Member

CREATE OR REPLACE FUNCTION abc(nbr NUMBER)
RETURN VARCHAR2
IS
str VARCHAR2(2000) := TO_CHAR(nbr);
BEGIN
RETURN str;
END;
/

Thu, 15 June 2000 07:36

Thierry Van der Auwera
Messages: 44
Registered: January 2000

Member

Hallo,

Just like this : SELECT TO_CHAR(num_field) FROM DUAL;

Greetings,
Thierry.

Previous Topic:	change column
Next Topic:	Case Sensitivity

Goto Forum:

]

Current Time: Fri Jun 02 00:20:58 CDT 2023