Data Types in PL/SQL

1. scalar data type (basic data type): a variable of this data type has only one value and has no internal component. It includes numeric, numeric, datetime, Boolean, for example, (varchar (2), number (P, S )).

2. attribute data type: A. % rowtype: reference a row in the database table as the data type, record type (record type), you can use ". "To access the attributes in the record, for example, myemp Scott. EMP % rowtype; the user must have the permission for this table. B. % Type: reference the type of a column in the table as the Data Type of the variable. You can also reference the type of a variable as the Data Type of the new variable. For example: Sal Scott. EMP. Sal % type: the type of the Sal column in the EMP table, or mysal number: = 3; totalsal mysal % type; the new variable total is the type of the variable mysal.