Why Indexes?
Basic use of index is to find data in a table more quickly by speeding up the query searches. Consider an employees table with 1 million records. If I query the table to extract data for 1 employee based on emp_id, all the records are compared for the emp_id. This approach will be very time taking in real time when many queries are searching for records. Thus we should use indexes to speed up the searching process.
CASE statement is used to select one out of many set of statements to execute.
Types of CASE statements:
The purpose of the following guide will be to provide a simple step by step guide on how to install RedHat Enterprise Linux 7.1 over an Oracle VirtualBox VM.
You will need to meet the following pre requisites before you can folow this guide.
I had some difficulty working with these 3 commands back when I was learning SQL particularly when deciding which one to use. SO, I've dedicated this blog to differentiating the three of them.
DELETE: used to remove rows selectively from a table. Delete is a DML command, so it will cause any delete triggers on the table to fire. You may need to explicitly commit after deleting from a table to make changes permanent.
So folks, I’m not going to explain the trigger syntax here as its same for all types of triggers. I’ll start off with INSTEAD OF trigger straight away.
INSTEAD OF triggers hold a special functionality as they can be used to update views which are normally not updateable and perform insert, update, delete, merge operations on them.
Introduction
Module overloading is a concept used across many programming languages mainly because it’s a very powerful feature which improves the usability of your software.
Introduction
Installing and configuring most of the Oracle Fusion Middleware products in single instance is usually a very straightforward affair.
Another cool and powerful feature that gives us the independence of carrying out a specific task as a separate transaction while inside the main transaction. The main transaction merely suspends for the duration the autonomous transaction runs.
It has great applications and uses while writing pl/sql code.
What is the difference between dynamic sql and static sql?
Dynamic sql refers to statements that are constructed and executed at runtime. Whereas static sql statements are constructed when the pl/sql block containing the statement is compiled.