Thursday, September 15, 2011

FUNCTIONS

Functions can be categorized as follows.


Ø  Single row functions
Ø  Group functions

SINGLE ROW FUNCTIONS

Single row functions can be categorized into five. These will be applied for each row and produces individual output for each row.

Ø  Numeric functions
Ø  String functions
Ø  Date functions
Ø  Miscellaneous functions
Ø  Conversion functions
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Oracle Escape Characters

Oracle allows the assignment of special escape characters to tell Oracle that the character is interpreted literally.  Certain characters ...

  • Columns to Rows
                        UNPIVOT (11g) Transforming columns into rows is easily accomplished with the SELECT command's UNPIVOT clause, intro...
  • Rows to Strings in Different Methods
    In this section show how to collect values from multiple rows into a single, delimited string. This process is commonly known as "strin...
  • Oracle Optimizer hint tips
    With each new release of Oracle, there are more tuning controls and opportunities for improving the execution speed of SQL. In an  article ...