- SQL
- March 28, 2026
Understanding Oracle Hints For PARALLEL Operations
The Oracle PARALLEL hint instructs the optimizer to use a specified number of concurrent servers (degree of parallelism, or DOP)…
- PL/SQL
- April 5, 2025
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…
- PL/SQL
- March 6, 2025
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…
- PL/SQL
- March 6, 2025
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…
- SQL
- January 30, 2025
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…
- Performance Tuning
- December 8, 2024
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…
- Performance Tuning
- December 8, 2024
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…
- Performance Tuning
- December 8, 2024
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…
- Performance Tuning
- October 29, 2024
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…
- Performance Tuning
- October 29, 2024
Understanding RANGE PARTITION In Oracle Database.
Use RANGE PARTITION when you want to access data on a frequent basis in a large table based on some…
- Performance Tuning
- October 29, 2024
Understanding LIST PARTITION In Oracle Database.
Use list partition when you already have a predefined set of values for which you are expecting the data.You should…