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;

Oracle PL/SQL Alter Table

Alter Table Example:

ALTER TABLE offers
RENAME TO news_offers;
  
ALTER TABLE offers
ADD details varchar2(1000);
  
ALTER TABLE offers
MODIFY details varchar2(800);  
  
ALTER TABLE offers
DROP COLUMN details;   
  
ALTER TABLE offers
RENAME COLUMN amount to new_amount;  

alter table OFFERS
add constraint FK_CUSTOMER_ID foreign key (CUSTOMER_ID)
references CUSTOMERS (CUSTOMER_ID);

alter table OFFERS
add constraint FK_PRODUCT_ID foreign key (PRODUCT_ID)
references PRODUCTS (PRODUCT_ID);

alter table OFFERS
add constraint FK_USER_CODE foreign key (USER_CODE)
references USERS (USER_CODE);