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
negative regexp
-
if you want to grep anything except foo, use grep -v or negative lookahead
echo -e 'foo\nbar\nboz'|grep -P '^(?!.*foo).*$' bar boz it is just so
beautiful ...
1 month 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