How to add a Column to a Table in Oracle

Here is the statement to add a column to a table.

ALTER TABLE SAMPLE_TABLE ADD  ANOTHER_DATE DATE;

Here is the statement to add multiple columns to a table.

ALTER TABLE SAMPLE_TABLE ADD (
ANOTHER_STRING VARCHAR2(100 CHAR),
ANOTHER_NUMBER NUMBER(32,12)
);

 

Leave a Reply