Home » RDBMS Server » Server Utilities » converting numbers in a char datatype
converting numbers in a char datatype [message #368355] Thu, 30 November 2000 11:49 Go to next message
Preeti
Messages: 14
Registered: November 2000
Junior Member
HI,
My datafile has the foll values:
'100'
'34.5'
and so on..basically some are integer values and some are floats but they're enclosed within quotes.
the col has a varchar2(6) datatype.

I need the column in the table to get the values:
'100.0'
'34.5'
ie. all of the values shd have a decimal point.

Report message to a moderator

Re: converting numbers in a char datatype [message #368391 is a reply to message #368355] Tue, 12 December 2000 16:21 Go to previous messageGo to next message
sriram
Messages: 58
Registered: September 2000
Member
Use Substring Function to identify it is a whole no or not ( by checking for pt in it) . if it does not, concat '0'

Report message to a moderator

Re: converting numbers in a char datatype [message #368394 is a reply to message #368391] Tue, 12 December 2000 16:57 Go to previous message
Preeti
Messages: 14
Registered: November 2000
Junior Member
Thank you..thats so simple...

Report message to a moderator

Previous Topic: imp80
Next Topic: Enterprise Backup Utility (EBU)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 05:30:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.