Keep it Simple and Smart
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 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 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 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 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