15일차 # 6-3: Composite Data Types

Composite Data Types : Hold multiple values

  * Using PL/SQL Collections and Records ==> http://goo.gl/VMgrA

  * PL/SQL record

- can have DIFFERENT data types

- related but dissimilar data as a logical unit

- access and modify data EASILY

- fields

- PL/SQL record structure: # 6-8

  * PL/SQL collection

- SAME data type (can be of the composite type)

1) Associative array (INDEX BY table)

2) Nested table

3) VARRAY

  * 선언부에서 TYPE 이용해서 정의한 후 선언부에서 선언

  * Collection Types ==> http://goo.gl/oPpoE