Tag: PLSQL
After you have announced the cursor in Oracle, the next step to open the cursor is to use the OPEN operator. Syntax of the OPEN operator OPEN cursor name; Options and arguments of the...
The cursor is certain operator SELECT which is declared in PLSQL code. Let's consider three different syntaxes of the cursor declaration. A CURSOR WITHOUT PARAMETERS (SIMPLE) Cursor...
The Oracle PL/SQL operator WITH allows you to give a subquery block a name/allowable that can be referenced in several places in the main SQL query.The name assigned to the subquery is...
In this tutorial you will learn how to use Oracle ALIASES (aliases for columns or tables) with syntax and examples.Oracle ALIASES can be used to create an alias for a column or...
In Oracle PLSQL Synonym is an alternative name for objects such as tables, views, sequences, stored procedures and other database objects.Typically, you use synonyms when you provide access...
In Oracle/PLSQL, you can create autonumbering using a sequence. A sequence is an Oracle object that is used to generate a number sequence. This can be useful when you need to create a unique...
In Oracle Packages a set of elements: procedures, functions, type definitions; declarations of variables, constants can be combined into a package.After writing, the PL/SQL package is...
Dynamic SQL makes your programs more flexible by creating and processing SQL sentences at runtime.With Dynamic SQL you can directly execute most types of SQL statements, including data...
Once you have created a trigger in Oracle, you may need to remove it from the database. You can do this with the DROP TRIGGER command. DROP TRIGGER syntax DROP TRIGGER name_trigger;Trigger...
In this tutorial you will learn how to create an AFTER DELETE trigger (after removal) in Oracle with syntax and examples.Oracle executes (excites) the AFTER DELETE trigger after the DELETE...
In this tutorial you will learn how to create a trigger BEFORE DELETE (before deleting) in Oracle with syntax and examples.Oracle executes (excites) the BEFORE DELETE trigger before executing...
In this tutorial you will learn how to create an AFTER UPDATE trigger (after updating) in Oracle with syntax and examples.Oracle executes (excites) the AFTER UPDATE trigger after running the...
In this tutorial you will learn how to create a BEFORE UPDATE trigger (before updating) in Oracle with syntax and examples.Oracle executes (excites) the BEFORE UPDATE trigger before executing...
In this tutorial you will learn how to create an AFTER INSERT trigger (after inserting) in Oracle with syntax and examples.Oracle executes (excites) the AFTER INSERT trigger after executing...
In this tutorial you will learn how to create a BEFORE INSERT trigger (before inserting) in Oracle with syntax and examples.Oracle executes (excites) the BEFORE INSERT trigger before executing...
Oracle Procedure is a subprogram that performs a specific action.Learn how to create and delete procedures in Oracle / PLSQL with syntax and examples. CREATE PROCEDURE As with other...