Tuesday, September 20, 2011

String to Rows

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...
  • 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 ...
  • Oracle WMSYS Functions
    conn wmsys/wmsys WM_CONCAT   Cross-tabulates a comma delimited list   WM_CONCAT(p1 IN VARCHAR2) RETURN VARCHAR2   CREATE TABLE t ( c...