Example query to add a column in Oracle

-- Add a new column
ALTER TABLE example_table ADD example_column VARCHAR2(5) DEFAULT 'example_default';

-- Add a comment on it
COMMENT ON COLUMN example_table .example_column IS 'example column comment';