Oracle | Varinder Sandhu

Oracle – PL-SQL- Introduction of Triggers

Varinder Sandhu Oracle, Oracle-Triggers, Varinder Sandhu

A 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 a unit and can invoke stored procedures. However, procedures and triggers differ in the way that they are invoked. A procedure is explicitly run by a user, application, or trigger.

» Read more

Oracle, Trigger

Oracle – PL-SQL – SYS_GUID

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

SYS_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 or thread. Example

» Read more

globally unique identifier, Oracle, RAW value, SYS_GUID

Oracle – PLSQL – NVL Function

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

NVL 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 different, then Oracle Database implicitly converts one to the other. If they are cannot be converted implicitly, the database returns an error.

» Read more

converts, NVL Function, Oracle

Oracle – Data Type – Difference between Column Type and Row Type

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

Column 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 cursor: Example:

» Read more

%ROWTYPE, %TYPE, Column Type, Oracle, Row Type

Oracle – SQL Developer – Anonymous Block Completed

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

Oracle 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 below in the snapshot) then we can see the output of script. Example Note: Anonymous block An ANONYMOUS BLOCK is a PL/SQL program that has no name and not

» Read more

Anonymous Block Completed, DBMS_OUTPUT.PUT_LINE, Oracle

Oracle 11 G Release 2 – Installation Steps

Varinder Sandhu Oracle, Oracle 11 G, Varinder Sandhu

Once 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 choose any option as per your requirement Here create and configure a database Choose as per your requirement Provide the Configuration setting as you require. Default Global Database Name is

» Read more

11 G Relaese 2, Installation Steps, Oracle

« 1 2 3