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)
TIME_BUCKET group by time period
-
We all know how to sum up by year select
to_char(trunc(hiredate,'Y'),'YYYY') year, count(*) from scott.emp group by
trunc(hiredate,'Y') order by trunc(hire...
1 week 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