Using Varrays in Temporary Tables : Temporary Table « Table « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Table
  3. Temporary Table
CREATE Or Replace TYPE addressVarray AS VARRAY(2) OF VARCHAR2(50)
/
CREATE GLOBAL TEMPORARY TABLE employee (
  id         INTEGER PRIMARY KEY,
  first_name VARCHAR2(10),
  last_name  VARCHAR2(10),
  addresses  addressVarray
)
/








6.20.Temporary Table
6.20.1.create global temporary table
6.20.2.Global temporary table and connection
6.20.3.create global temporary table transaction_tab on commit delete rows
6.20.4.Create a temporary table whose rows will be deleted at the end of a session by specifying ON COMMIT PRESERVE ROWS
6.20.5.Using Varrays in Temporary Tables