Wednesday, September 14, 2011

Introduction of Oracle

SQL is divided into the following


Ø  Data Definition Language (DDL)
Ø  Data Manipulation Language (DML)
Ø  Data Retrieval Language (DRL)
Ø  Transaction Control Language (TCL)
Ø  Data Control Language (DCL)

DDL -- create, alter, drop, truncate, rename
DML -- insert, update, delete
DRL -- select
TCL -- commit, rollback, savepoint
DCL -- grant, revoke

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 ...