CREATE TYPE varray_type AS VARRAY(2) OF VARCHAR2(50); 

ALTER TYPE varray_type 
MODIFY ELEMENT TYPE varchar2(100) CASCADE;

ALTER TYPE vrray_name
MODIFY LIMIT 5 CASCADE;

CREATE TABLE table_name(
column_name type,
var_col_name varray_type
);

DESC[RIBE] varray_type;

SELECT * 
FROM user_varrays
WHERE type_name = varray_name;

INSERT INTO table_name VALUES(
 value,
 varray_type(
  'xxxx',
  'xx',
  'x')
);

SELECT *
FROM table_Name;

UPDATE table_name
SET var_col_name = varray_type('xxx','xxxxxx')
WHERE expr1;

CREATE TYPE table_type AS TABLE OF type;

CREATE TABLE table_name(
 column_name type,
 tab_col_name table_type
)
NESTED TABLE
 table_col_name
STORE AS
 next_table_name [TABLESPACE user_name];

SET DESCRIBE DEPTH 2
DESC[RIBE] table_name;

SELECT *
FROM user_nested_tables
WHERE table_name = xxxx;

INSERT INTO TABLE(
 SELECT tab_col_name FROM table_name WHERE expr)
 VALUES(
  table_type('xxxx')
 )
);

UPDATE TABLE(
 SELECT tab_col_name FROM table_name WHERE expr
) T
SET
 VALUE(T) = table_type(
  'xxxx')
)
WHERE 
 VALUE(T) = table_type(
  expr2
  );

DELETE FROM TABLE(
 SELECT tab_col_name FROM table_name WHERE expr
)T
WHERE
 VALUE(T) = table_type(
  expr2
 );