December 23, 2013 at 1:45 am
Similiar thing for flaot values can we get..!
for decimal values is it is possible...
Select utl_raw.cast_to_varchar2(utl_raw.CAST_FROM_BINARY_FLOAT(.2635)) from dual;
>†éy
December 23, 2013 at 1:54 am
David Burrows (12/19/2013)
DECLARE @test varchar(max)
SET @test = CHAR(1)+CHAR(87)+CHAR(179)
SELECT CAST(CAST(SUBSTRING(@test,1,3) as varbinary(3)) as int)
how do u made CHAR(1)+CHAR(87)+CHAR(179) on which factor u decide if it is a dynamic one then how will u do
how to do it for vice versa...
Thanks for your suggestion..!
December 23, 2013 at 5:15 am
yuvipoy (12/23/2013)
David Burrows (12/19/2013)
DECLARE @test varchar(max)
SET @test = CHAR(1)+CHAR(87)+CHAR(179)
SELECT CAST(CAST(SUBSTRING(@test,1,3) as varbinary(3)) as int)
how do u made CHAR(1)+CHAR(87)+CHAR(179) on which factor u decide if it is a dynamic one then how will u do
how to do it for vice versa...
Thanks for your suggestion..!
If you would post a couple of rows of data and tell us what they contain, this could be all over in a minute or two.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 26, 2013 at 4:31 am
Pasting couple of rows is not a problem but what is the logic...?
December 26, 2013 at 5:02 am
yuvipoy (12/26/2013)
Pasting couple of rows is not a problem but what is the logic...?
Post the couple of rows and tell me what's in them and then we'll see what we can do.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy