Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database ? (Choose three .)
A.
addition
B.
subtraction
C.
raising to a power
D.
finding the quotient
E.
finding the lowest value
Which arithmetic operations can be performed on a column by using a SQL function that is built intoOracle database ?
Which arithmetic operations can be performed on a column by using a SQL function that is built into
Oracle database ? (Choose three .)
why not substraction?
can anybody explain it?
I think:
“using a SQL function” !!! and (Choose three .)
Test case:
select sum(t.val) –addition
from (select 1 as val from dual union all select 10 from dual)t
select power(t.val,2) –raising to a power
from (select 1 as val from dual union all select 10 from dual)t
select min(t.val) –finding the lowest value
from (select 1 as val from dual union all select 10 from dual)t
SQL function for subtraction? I don’t know…:
select subtraction(t.val) — 🙂
from (select 1 as val from dual union all select 10 from dual)t
can anybody explain why option B is incorrect????
There is no substraction function for arithemtic operations built into Oracle SQL.
Always a big fan of linking to bloggers that I like but really don’t get a great deal of link really like from.
Here are a few of the sites we recommend for our visitors
we came across a cool internet site which you may possibly enjoy. Take a search for those who want
just beneath, are a lot of totally not connected internet sites to ours, however, they are surely really worth going over
the time to study or pay a visit to the subject material or web pages we have linked to beneath the
here are some links to internet sites that we link to simply because we consider they may be worth visiting
The information and facts talked about inside the report are some of the best obtainable
we like to honor a lot of other net web pages around the web, even when they arent linked to us, by linking to them. Beneath are some webpages really worth checking out
one of our visitors a short while ago advised the following website
Every as soon as in a when we opt for blogs that we study. Listed beneath are the most current web-sites that we opt for
always a big fan of linking to bloggers that I like but really don’t get a lot of link adore from
here are some links to sites that we link to mainly because we feel they may be worth visiting
very few sites that occur to become detailed beneath, from our point of view are undoubtedly properly worth checking out
just beneath, are several absolutely not related sites to ours, even so, they’re surely really worth going over
Every when inside a though we select blogs that we read. Listed below would be the latest web-sites that we pick out
usually posts some pretty exciting stuff like this. If youre new to this site
although internet websites we backlink to beneath are considerably not related to ours, we really feel they may be basically really worth a go through, so possess a look
check beneath, are some entirely unrelated websites to ours, on the other hand, they may be most trustworthy sources that we use
usually posts some pretty intriguing stuff like this. If you are new to this site
Sites of interest we have a link to
please stop by the sites we stick to, including this one particular, as it represents our picks from the web
just beneath, are a lot of absolutely not associated websites to ours, on the other hand, they’re surely really worth going over
please check out the web-sites we follow, such as this a single, because it represents our picks from the web
A = SUM()
C = POWER(x, y)
E = MIN()