Summary: in this tutorial, you will learn how to use the Oracle ALTER TABLE statement to modify the table structure.
To modify the structure of an existing table, you use the ALTER TABLE statement. The following illustrates the syntax:
ALTER TABLE table_name action;
Code language: SQL (Structured Query Language) (sql)
In this statement:
First, specify the table name which you want to modify.
Second, indicate the action that you want to perform after the table name.
The ALTER TABLE statement allows you to:
Add one or more columns
Modify column definition
Drop one or more columns
Rename columns
Rename table
#oracleplsql #banglatutorial #oracle #trustcoding #786ahsanarif #education #oraclejavacertification #bangla #universityofscholars
Download
0 formats
No download links available.
Oracle ALTER TABLE - add - modify - drop - rename #oracleplsql #banglatutorial #oracle | NatokHD