1. Introduction The %ROWTYPE attribute enables you declare a record that represents either a partial or full row of a database table or view. For every column of the full or partial row, the record has a field with the same data type and name. If the structure of the row changes, then the structure…

1. Introduction The %TYPE attribute lets you declare a data item of the same data type as a previously declared variable or column. It is not necessary to know the type of the variable while using %TYPE attribute.For example, if you want to declare a variable in a PL/SQL block, which is of the same…

1. Introduction In this tutorial, we’ll discuss basic syntax of PL/SQL. There are three parts of PL/SQL subprogram. Declaration part This section starts with the DECLARE. This section is used for declarations of local types, variables and subprograms. This section is optional. Declarations are local to the block and cease to exist when the block…

1. Introduction In this tutorial, we’ll discuss about PL/SQL. We’ll also discuss its advantages, features and architecture. PL/SQL is the Oracle procedural extension of SQL. An SQL statement is a single statement and does not provide any functionality to group related SQL statements and treat the group as a unit. This problem can be solved…

1. Natural Key A natural key is a type of unique key in a database which has an equivalent in the external world outside the database. Database tables are used to represent entities in the real world. A natural key is some unique attribute or group of attributes of the real world entity which uniquely…