Keep it Simple and Smart
Error: 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 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 moreSYS_GUID generates and returns a globally unique identifier (RAW value) made up of 16 bytes. On most platforms, the generated identifiers consists of a host identifier, a process or thread identifier of the process or thread invoking the function, and a non repeating value (sequence of bytes) for that process
» Read moreNVL lets you replace null with a string in the results of a query. Syntax NVL (string1, replace_with) If string1 is null, then NVL returns replace_with. If string1 is not null, then NVL returns string1. Note: The arguments string1and replace_with can have any data type. If their data types are
» Read moreColumn Type Column Type (i.e. %TYPE) is used to declare a field with the same type as that of a specified table’s column: Example: Row Type Row type (i.e. %ROWTYPE) is used to declare a record with the same types as found in the specified database table, view or
» Read moreOracle SQL Developer does not display the output of DBMS_OUTPUT.PUT_LINE, it gives “anonymous block completed” in the script output tab Some time we are confused why this is giving message “anonymous block completed” To see the output of script, we need to enable DBMS_OUTPUT by clicking on plus symbol (see
» Read moreOnce you download the Oracle 11 G Release 2 Installer from http://www.oracle.com/technetwork/index.html Click on Setup Files to Start Installing Oracle on your system You need to enter your email id. If you require updated from Oracle. Here we have not given any email id for demo Click “Yes” You can
» Read moreVarinder Sandhu is using WP-Gravatar