oracle insert optional column in middle of table code example Example: oracle add column ALTER TABLE table_name ADD column_name data_type constraint;