Oracle Trigger

Introduction A trigger is a stored procedure in a database that is called automatically whenever a certain event occurs in the database e.g. A trigger can be triggered when a row is entered into a table or when A trigger is a stored procedure in a database that...

Oracle Cursor

Introduction A cursor is a pointer that leads to a query’s result. There are two sorts of cursors in PL/SQL: implicit and explicit cursors.   What is a cursor in Oracle In PL/SQL, cursors are used. For each SQL statement, Oracle constructs a memory region...

Oracle Function

Introduction Functions are code modules that are “self-contained” and perform a single task. Functions frequently “take in” data, process it, and “return” a result. Once you’ve written a function, you can use it...

Oracle Procedure

Introduction Procedures in Oracle are subprograms that are stored in the database and used to perform specified operations on the database’s or tables’ contents. Procedures, like any other program, should have a few mandatory parameters to successfully...

Oracle Joins

Introduction The basic definition of join means creating a combination or a group of items, so an SQL join is a way to combine rows from two or more tables based on a common column between them now let’s see how oracle joins works What are Oracle Joins A query...

Oracle Clauses

Introduction Oracle clauses are conditional keywords or sentences that allow you to query a database or table based on specific parameters. ‘Select’ fetches the contents of the database, ‘from’ mentions the table name, ‘where’ adds...