Oracle ALTER Table (DDL Commands) | Oracle SQL fundamentals

Опубликовано: 27 Декабрь 2018
на канале: DBA Genesis
969
11

The Oracle ALTER TABLE statement is used to add, #modify, or drop/delete columns in a table. The #Oracle #ALTER #TABLE statement is also used to #rename a table.

00:00 ALTER table command
01:23 ADD column
01:32 MODIFY column
01:49 RENAME column
01:59 DROP column
02:20 Making table read only
04:27 Mark column as unused
06:06 Delete all unused column

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis