Oracle PL/SQL As Keyword Example

SELECT sal * 2 AS "Salary" FROM emp;

CREATE TABLE cust_1276 
AS SELECT * FROM customers 
WHERE customer_id = 1276;


CREATE TYPE email AS OBJECT (email_adress VARCHAR2(80));


CREATE TYPE email_list AS TABLE OF email;


CREATE TYPE employees AS OBJECT (
name VARCHAR2(25),
emails email_list
);


CREATE TYPE employee_list AS TABLE OF employees;