Select any 3 of the functions provided in the Oracle Functions
Select any 3 of the functions provided in the Oracle Functions reading
this week. Provide your own unique queries using each of the functions. Be sure to describe each query and the output.
-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