Explain Alter Table Command

Explain Alter Table Command.

- Alter Table command is a DDL command that is used to change the definition of the table.
- Changing definition means changing datatype, width of columns or adding a new column in the table.
- Use the ALTER TABLE statement to alter the definition of a nonpartitioned table, a partitioned table, a table partition, or a table subpartition.
- For object tables or relational tables with object columns, use ALTER TABLE to convert the table to the latest definition of its referenced type after the type has been altered.
What are the limitations of Alter Table command?
Column can’t be deleted with alter command. Column can’t be renamed a column.....
Explain types of tables in oracle
In Oracle, tables are the basic storage units. There are several types of database tables. Different types of tables have different characteristics.....
Global temporary tables
The maintenance and management of temporary tables can be delegated to the server by using Global Temporary Tables.......
Post your comment