Learnitweb

Category: Oracle database tutorial

  • PL/SQL %ROWTYPE Attribute

    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…

  • PL/SQL %TYPE Attribute

    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…

  • PL/SQL – Basic Syntax

    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…

  • Overview of PL/SQL

    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…

  • Natural key and surrogate key

    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…