Types of composite data type

Explain the types of composite data type.

Following are the types of composite data types:

RECORD - PL/SQL records are similar to C structures. A record provides with a way to deal with separate but related variables as a unit.

TABLE - They are similar to arrays in C. However, they are implemented differently.

In order to declare a PL/SQL table, you need to first define a table type, then you declare a variable of this type
Oracle object datatypes
Oracle object datatypes - Object data types are user defined data types. Both column and row can represent an object type. Object types instance can be stored in the database....
Explain the constraints that can be applied to Oracle tables
The syntax of writing a table is create table tablename ( columnname type, columnname type ..., primary key(keycolumn);...
Types of constraints in Oracle
Not Null Constraint, Primary Key Constraint, References Constraint, Unique Constraint...
Post your comment
Discussion Board
Statement below
I copied the following statement from your site, "In order to declare a PL/SQL table, you need to first define a table type, then you declare a variable of this type".
I thought the declare comes before the define but you are saying the define comes before the declare. Which is right? I am a little confused. Please expand, thank you.
George A. Agbanrin 03-3-2015

Related Content

Follow us

▲