Oracle Trigger
18 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 […]
18 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 […]
16 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. […]
45 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 […]
15 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, […]
15 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 […]
17 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 […]
9 Introduction A query is not a programming language such as python,c,c++, java etc although it is a type of language used in Oracle databases to […]
25 Introduction There are several other objects in a database in addition to tables and those are views, sequences, indexes, and synonyms. Each database objects have […]
19 Introduction As we all know that a table can be defined as a collection of rows and columns but in the Relational Database management system […]
29 Introduction Today let’s have a look at the Oracle database and its features, but hold for a second! Before jumping into databases and their amazing […]