How to add a new column to an existing Table

Explain how to add a new column to an existing Table in Oracle.

- 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.

Example:
ALTER TABLE employee ADD (department VARCHAR2);
How many types of Tables supported by Oracle?
How many types of Tables supported by Oracle? - Oracle supports 4 types of tables based on how data is organized in storage.....
What is trigger in oracle?
Triggers are constructs in PL/SQL that need to be just created and associated with a table....
What are the types of triggers?
The different types of triggers are: Row triggers and statement triggers: specifies how many times the trigger should get executed – Once for every row or once for every triggering statement....
Post your comment

Related Content

Follow us

▲