How do you declare a PL/SQL table? Explain it with an example.

What will be an ideal response?

A PL/SQL TABLE declaration is done in two steps, like a record declaration:
? Declare a PL/SQL Table type with a TYPE statement. The structure could use
any of the scalar data types.
? Declare an actual table based on the type declared in the previous step.
For example, TYPE position_name_table_type IS TABLE OF position.PosDesc%TYPE INDEX BY BINARY_INTEGER; Position_table position_name_table_type;