====== Oracle - SQL - Table - Alter Table ======

<code sql>
ALTER TABLE table_name
ADD column_name datatype
</code>

or

<code sql>
ALTER TABLE table_name
DROP COLUMN column_name
AS (alias) 	SELECT column_name AS column_alias
FROM table_name
</code>

or

<code sql>
SELECT column_name
FROM table_name  AS table_alias
BETWEEN 	SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2
</code>