Home » SQL & PL/SQL » SQL & PL/SQL » query
query [message #9448] Tue, 11 November 2003 03:02 Go to next message
praj
Messages: 1
Registered: November 2003
Junior Member
how to convert from string to unmber while executing query.. like Order By to_val(number);

number is stored in table as character.
want to convert it to number again.
any function in place of to_val????????????

Report message to a moderator

Re: query [message #9449 is a reply to message #9448] Tue, 11 November 2003 03:51 Go to previous message
Vishal
Messages: 86
Registered: August 2000
Member
TO_NUMBER(chardata)

Report message to a moderator

Previous Topic: alter table col
Next Topic: De-normalization of tables and explain Plan
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 21:48:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.