Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

The optional precision defaults and

Built-in function


Returns the remainder of n divided by m. The remainder is

REMAINDER(n, m) Returns the remainder of n divided by m. The remainder is defined as follows: n−(m*ROUND(n/m)).

ROUND(n) Returns n rounded to the nearest integer.

SQRT(n) Returns the square root n, which must be greater than or equal to 0.

TAN(n) Returns the tangent of the angle n, which must be expressed in radians.

Built-in Functions and Packages | 95
Returns the hyperbolic tangent of n. If n is a real number,

TRUNC(n [, p]) Truncates n to m decimal places. The optional precision p defaults to 0 and, if negative, truncates (zeros out) p places to left of the decimal.

Date and time functions

MULTISET(subquery) } AS type)

collection type to another. Use the MULTISET keyword when casting to a collection type.

DBTIMEZONE Returns the time zone offset (from UTC) of the database time zone in the form of a character string in format [+|-]HH24:MI; for example, -05:00.

EXTRACT(element FROM Returns the value of a specific datetime expression) element from the datetime expression. The element can be one of YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, TIMEZONE_HOUR, TIMEZONE_MINUTE, TIMEZONE_REGION, or TIMEZONE_ABBR.

96 |
How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELI1BF6500
Uploaded by :
Page 1 Preview
the optional precision defaults and
Sell Your Old Documents & Earn Wallet Balance