Home » SQL & PL/SQL » SQL & PL/SQL » Convert number to string
Convert number to string [message #365159] Tue, 13 June 2000 15:44 Go to next message
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;
/
Re: Convert number to string [message #365162 is a reply to message #365159] Thu, 15 June 2000 07:36 Go to previous message
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: Thu Jun 17 17:50:38 CDT 2021