Oracle - SQL Table Basics - Altering/Adding Columns

Adding column

You can add new columns to an existing table.

ALTER TABLE PHONE
      MODIFY ( INACTIVE_DATE DATE ) 
/

Alter column

You can add modify an existing column

ALTER TABLE PERSON
      MODIFY ( LASTNAME VARCHAR2(35) )
        /
        

Considerations for altering a column

Alter columns - No Can Do

 Collapse All    Expand All
Custom Search

Oracle Information and Resources