Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Thursday, 31 March 2016

SQL Numeric Functions

Absolute value is the measure of the magnitude of value.
Sign gives the sign of a value.
This will give the square root of the given value.
This will give the remainder.
This will substitutes the specified value in the place of null values.
NVL2 Function we can pass three parameters if first parameter is not null it returns second parameter. if first parameter is null it return third parameter
Power is the ability to raise a value to a given exponent.
This will raise e value to the give power.
This is based on natural or base e logarithm.
This is based on 10 based logarithm.
This will produce a whole number that is greater than or equal to the specified value.
This will produce a whole number that is less than or equal to the specified value.
This will rounds numbers to a given number of digits of precision.
This will truncates or chops off digits of precision from a number.
This will perform bitwise and operation.
This will give the greatest string.
This will give the least string.
This will gives the first non-null string.
Share this article :


  1. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check

  2. Numerology was used to describe the personality of a person and predict the map for his/her life using his/her birth date and name. This predictive science that uses numbers just as astrology uses the planets, has garnered much interest in it as a reliable tool for guidance in life.2:02

  3. Numerology indicates what is likely to happen and its preventing measures. Numerology can guide,us about our character, talents, purpose in life etc.angel numbers 4444

  4. No matter what your reason for trying to make an impact on someone, numerology can go a long way towards assisting you in figuring out what makes someone lean in your favor. Consulting the numbers does really work.Numerology Basics

  5. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  6. Get your updated horoscope chart and many more interesting information from Indian astrology online online nadi astrology