Category: PL/SQL

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...

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...