Monday 28 October 2013

Persistent and non-persistent collections

Index-by tables cannot be stored in database tables, so they are non-persistent.
You cannot use them in a SQL statement and are available only in PL/SQL blocks.

Nested tables and Varrays are persistent. You can use the CREATE TYPE statement to create them in the database; you can read and write them from/to a database column.

Nested tables and Varrays must have been initialized before you can use them.

No comments:

Post a Comment