select with A NEW COLUMN plsql code example

Example: oracle add column

ALTER TABLE table_name 
ADD column_name data_type constraint;