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
no salary should be 25x higher than the lowest salary
-
This is common sense How to enforce this in a recent Oracle version? create
assertion x25 check (not exists(select * from emp e where sal*25<any(select
sal...
2 days 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