by Barry Allen | Jan 7, 2022 | Oracle Database
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... by Barry Allen | Jan 7, 2022 | Oracle Database
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... by Barry Allen | Jan 7, 2022 | Oracle Database
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... by Barry Allen | Jan 7, 2022 | Oracle Database
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... by Barry Allen | Jan 7, 2022 | Oracle Database
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... by Barry Allen | Jan 7, 2022 | Oracle Database
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...