Oracle - SQL - Table - Alter Table

ALTER TABLE TABLE_NAME
ADD column_name datatype

or

ALTER TABLE TABLE_NAME
DROP COLUMN column_name
AS (alias) 	SELECT column_name AS column_alias
FROM TABLE_NAME

or

SELECT column_name
FROM TABLE_NAME  AS table_alias
BETWEEN 	SELECT column_name(s)
FROM TABLE_NAME
WHERE column_name
BETWEEN value1 AND value2