OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » CONVERSIONS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CONVERSIONS [message #587298]

Fri, 14 June 2013 01:04

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

I WANT TO CONVERT 75.1 TO 75.5,75.6 TO 75.10 WHAT IS THE LOGIC BEHIND THAT.

Report message to a moderator

Re: CONVERSIONS [message #587300 is a reply to message #587298]

Fri, 14 June 2013 01:11

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There's no logic behind that.

Report message to a moderator

Re: CONVERSIONS [message #587301 is a reply to message #587298]

Fri, 14 June 2013 01:14

John Watson
Messages: 8981
Registered: January 2010
Location: Global Village

Senior Member

I don't know what the logic is! You will have to explain. Begin by saying whether the data are strings or numbers, then the rules for the conversion.

Report message to a moderator

Re: CONVERSIONS [message #587303 is a reply to message #587298]

Fri, 14 June 2013 01:24

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Based on what you have supplied:

CASE your_col
    WHEN '75.1'
    THEN '75.5'
    WHEN '75.6'
    THEN '75.10'
END

Obviously this is a somewhat facetious answer, but it makes a point.

Report message to a moderator

Re: CONVERSIONS [message #587304 is a reply to message #587298]

Fri, 14 June 2013 01:25

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You want to do something but you don't know what is the logic behind this?
Gee! seems the number of neurons in the posters decreases each day; we are now below the bugs.

Regards
Michel

Report message to a moderator

Previous Topic:	How to query for columns without using column names
Next Topic:	UTL_FILE READ TAKING TIME

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 08 05:50:13 CDT 2025