Author: Dev

In Oracle PL/SQL, the RECORD data type is used to define a composite data type that consists of one or more fields. A RECORD data type is similar to a row in a database table, but it is not associated with any particular table. Instead, it is used to group related data items together into…(Continue Reading)

Oracle PL/SQL REF CURSOR is a datatype used to store a cursor reference in a PL/SQL block. It is a type of data that refers to a cursor, which is essentially a memory area that stores the results of a query. A REF CURSOR is a named cursor that can be opened and used within…(Continue Reading)

In Oracle PL/SQL, the VARCHAR data type is used to store character strings of variable length. A VARCHAR column can store alphanumeric data and symbols, such as letters, numbers, and special characters, up to a maximum length specified during declaration. Syntax The syntax for declaring a VARCHAR variable or column is as follows: DECLARE —…(Continue Reading)

Oracle PL/SQL UROWID is a data type used to store the unique row ID of a row in a table. The UROWID data type is a binary data type that is used to uniquely identify a row in a table. It is a pseudo column that is automatically created by Oracle for each row in…(Continue Reading)

In Oracle PL/SQL, the CHARACTER data type is used to store fixed-length strings of characters. It is also sometimes referred to as CHAR. When you define a CHAR variable or column, you need to specify the maximum length of the string it can hold. For example, if you define a CHAR(10) variable, it can hold…(Continue Reading)