Let us suppose we have a table column which is incrementing its value with an existing sequence. Now we want to create a …
We can compile Triggers through many ways.
To identify uncompiled Triggers we have to query USER_OBJECTS data dictionary view.
Identifying complete list …
We will check in this article possible ways to convert a Ref cursor to a Table.
We need to create a setup to test the scenario.
First we will create a package to get …
We will create two packages to test the calling.
1st Package: PKG_EMP_DATA
This package will extract information about employees of a specific department.
--Queries…
We will check multiple ways to update rows using join condition.
--Update multiple rows in Oracle using Join: Setup
CREATE TABLE EMP_JOIN_TEST
AS
SELECT EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
JOB_ID,
… In this article we will see how to fetch multiple columns and rows from a cursor.
We will check 3 ways to fetch multiple columns from a cursor:
We will examine different ways to fetch data from ref cursor.
We will use SYS_REFCURSOR as ref cursor variable as its a week type of cursor.
It will …
We can create a table in oracle based on structure or data or both of another table.
First we will create a test table to check all the scenarios.