Change Table Definition | Oracle SQL Developer

Published: 18 October 2018
on channel: DBA Genesis
2,227
7

This video explains how to use the #Oracle #ALTER #TABLE #statement to add a #column, modify a column, #drop a column, #rename a column or rename a table (with #syntax, examples and practice exercises).
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 Close SQL Developer
01:37 Change the table definition
02:03 Add a new column
03:18 Rename a table

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