Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to calculate the fifth root

Martin1Apr 2 2010 — edited Apr 2 2010
Hi,

i'm searching for a sql function to calculate the fifth root of a given negative number.
By the way the sql function POWER doesn't work - see the following from the sql reference documentation:
The base and the exponent can be any numbers, but if the base is negative, then the exponent must be an integer.

In MS Excel i would do it this way: -.25^(1/5)

Has somebody an idea for a workaround?

Many thanks in advance.

Best Regards,
Martin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2010
Added on Apr 2 2010
#database, #pl-sql, #sql
4 comments
1,088 views