Problem: Write an SQL query to convert a binary number to its Decimal equivalent.
Solution:
select sum(substr(&binary_number,rownum,1)*power(2,length(&binary_number)-rownum)) decimal_number from all_objects
where rownum<=length(&binary_number)
Posts
tnsping and instant client revisited
-
You enjoyed my old trick with
https://laurentschneider.com/wordpress/2012/11/tnsping-and-instant-client.html
? you will love this one ❤️ sqlplus -p db01 Lo...
3 weeks ago
1 comment:
Nice post. I was checking continuously this blog and I am impressed!
Extremely helpful information particularly the last part :) I care for
such information a lot. I was looking for this certain info for a long time.
Thank you and best of luck.
my blog top online casinos (http://oboeguilty27.jigsy.com/entries/general/Steps-For-making-Your-Best-Online-Casinos-A-Success)
Post a Comment