Wednesday, September 10, 2008


  • Enable storage of multiple values for a single column per row
  • Number of multiple values are fixed by definition
  • Limited to one column per table
  • Array values are stored in the table itself (in line storage)
  • Query performance likely to suffer
  • Indexing a varray column is not possible
  • Selection of array values is complex
  • DML operations require use of constructor methods
  • NULL values need to be specified explicitly

No comments: