One-stop resource for everything related to
Oracle Database

XMLType

Understanding XMLType In Oracle Database.

XMLType is used to store and manipulate XML data. You can use XMLType to define database columns and PL/SQL variables…

XMLType

Understanding XMLType In Oracle Database.

XMLType is used to store and manipulate XML data. You can use XMLType to define database columns and PL/SQL variables…

XMLType

Understanding CASE Statement & CASE Expression In Oracle Database.

• Simple CASE statement evaluates a expression and executes the statement or sequence of statements associated with the first condition…

compound trigger

Understanding Compound Trigger In Oracle Database.

In real world, as you create more and more triggers containing more and more business logic, it becomes difficult to…

RETURNING INTO

Understanding RETURNING INTO Clause In Oracle Database.

The RETURNING INTO clause specifies the variables in which to store the values returned by the statement to which the…

RETURNING INTO

Understanding OPEN FOR Statement In Oracle Database.

OPEN FOR statement is used to support multiple-row dynamic queries. OPEN cursor_variable|host_cursor_variable} FOR sql_string USING bind_argument; The bind_argument is always…

RETURNING INTO

Understanding SELECT FOR UPDATE In Oracle Database

The SELECT FOR UPDATE statement is a special variation of the normal SELECT statement, which proactively issues row locks on…

RETURNING INTO

Understanding COMPOSITE/SUB PARTITION In Oracle Database.

Composite partitioning OR sub partitioning is a partitioning technique in which the table is initially partitioned by the first data…

RETURNING INTO

Understanding HASH PARTITION In Oracle Database.

Hash partitioning is a partitioning technique where a hash key generated through a hashing algorithm is used to distribute rows…

RETURNING INTO

Understanding INTERVAL PARTITION In Oracle Database.

Interval partitioning method is introduced in Oracle 11g. This is an extension to range partitioning where Oracle automatically creates a…

RETURNING INTO

Understanding REFERENCE PARTITION In Oracle Database.

Reference partitioning is a partitioning method introduced in Oracle 11g. Using reference partitioning, a child table can inherit the partitioning…