Define what an Oracle function is. Describe, in general, how you use a function.

• From the 'Oracle Functions' reading this week, select any 3 of the functions and provide a brief definition and description of what each function does. The functions are below:

 

About SQL Functions

Single-Row Functions

Numeric Functions

Character Functions Returning Character Values

Character Functions Returning Number Values

Character Set Functions

Datetime Functions

General Comparison Functions

Conversion Functions

Large Object Functions

Collection Functions

Hierarchical Functions

Data Mining Functions

XML Functions

Encoding and Decoding Functions

NULL-Related Functions

Environment and Identifier Functions

Aggregate Functions

Analytic Functions

Object Reference Functions

Model Functions

OLAP Functions

Data Cartridge Functions

About User-Defined Functions

 

• Also, for each of the functions that you've described in #2, provide your own unique queries using each of the functions. Be sure to describe each query and the output in great detail.

• Capture a screenshot of the successful execution of these queries and ensure those are visible in your initial post.