Keep it Simple and Smart
We can create a trigger with multiple actions (i.e. Â Insert or Update or Delete) here sharing an example of trigger in which we can handle three actions as insert, update and delete. Example: CREATE OR REPLACE TRIGGER EMPLOYEE_AI_AU_AD AFTER INSERT OR UPDATE OR DELETE ON EMPLOYEE FOR EACH ROW DECLARE
» Read moreDatabases, tablespaces, and datafiles are closely related, but they have important differences. It is important to know the differences for Newbie that‘s why sharing here. Databases:  An Oracle database consists of one or more logical storage units called tablespaces that collectively store all of the database data. Tablespace: Each tablespace
» Read more— CREATE TABLE CREATE TABLE EMPLOYEE ( ID NUMBER NOT NULL, FIRST_NAME VARCHAR2(10 BYTE), LAST_NAME VARCHAR2(10 BYTE) ); — INSERT SOME VALUES INTO TABLES INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME) VALUES (1,'VARINDER','SANDHU'); INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME) VALUES (2,'DINESH','SHARMA'); INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME) VALUES (3,'RANJOYT','SINGH'); INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME) VALUES (4,'VIKRAM','SINGH'); — CREATE
» Read moreWithin a trigger body of a row trigger, two correlation names exist for every column of the table being modified: one for the old column value, and one for the new column value. Depending on the type of triggering statement, certain correlation names might not have any meaning. Â A trigger
» Read moreError: ORA-04091: table name is mutating, trigger/function may not see it Cause: Mutating trigger error occurs when a trigger references the table that owns the trigger. So the result is we receive the above error message. Solution: We cannot refer the table in the trigger that owns the trigger. If
» Read moreA cursor is basically a set of rows that we can access one at a time. When we use the cursor, it means we have the select statement that returns the more than one row; we need to access the one row at a time. Working of Cursors Basically in
» Read moreA LOOP statement executes a sequence of statements multiple times. PL/SQL provides these loop statements: Numeric FOR_LOOP loops iterate over a specified range of integers. The range is part of an iteration scheme, which is enclosed by the keywords FOR and LOOP. The range is evaluated when the FOR loop
» Read moreEmail tracking is feature with the help that you can track your email (i.e. whether your email message was delivered to the recipient’s mailbox or recipient opens your email message.) There are two options for email tracking Delivery Receipt Read Receipt A delivery receipt tells you that your e-mail message
» Read moreThere are four types of triggers: Table-level triggers can initiate activity before or after an INSERT, UPDATE, or DELETE event. View-level triggers define to the view. Database-level triggers can be activated at startup and shutdown of a database. Session-level triggers can be used to store specific information.
» Read moreA trigger is a procedure that is run automatically by the database when a specified SQL DML INSERT, UPDATE, or DELETE statement is run against a table or view. Triggers are similar to stored procedures. A trigger stored in the database can include SQL and PL/SQL statements to run as
» Read moreVarinder Sandhu is using WP-Gravatar