Recent content by tekmilind

Thanks for the help. I am not still not able to get the output of -0.01. I have decided to use JAVA instead to do the biwise operations. Thanks a lot for all the help. Regards, Milind

You are absolutely correct. But here is my problem the actual formula is &quot;(((x[0]<<8)+x[1])/128) where x[0]=FF and x[1] is FF. The expected output value is &quot;-.01&quot;. Since oracle does not have left shift and right shift i have translated the formula to '(((x[0] * POWER(2...

I am getting the value as 0. x[0] and x[1] are in hexadecimal. Their values are FF. I am converting that to decimal to be substituted in the formula '(((x[0] * POWER(2, 8))+x[1])/128)'. Since there are no left shift operators in PL/SQL i am converting FF to decimal. Let me know if this...

Hi, I am facing some problems with bitwise operators in PL/SQL. The formula i have is : (((x[0]<<8)+x[1])/128) where x[0]=FF. The correct output value is &quot;-.01&quot;. I have translated the formula as (((x[0] * POWER(2, 8))+x[1])/128), but i am not able to get the float output. Thanks in...

Hi, I have to right (or left) shift binary numbers in Oracle PL/SQL. Is there any function that will achieve this? Thanks in advance for the help. - Milind

Hello, I have the BO server installed on a Win2K (Service Pack 2)machine. The desktop client is installed on a different machine (Win2K). The database i am using is MS-Access. It takes about 10 mins for the web interface to login after accepting the userid/password. Any help on this...