Oracle Alter Table Syntax  

Posted by Bhargav Tripathi

We have "alter table" syntax from Oracle to add data columns in-place in this form:

alter table
table_name
add
(
column1_name column1_datatype column1_constraint,
column2_name column2_datatype column2_constraint,
column3_name column3_datatype column3_constraint
);

Here are some examples of Oracle "alter table" syntax to add data columns.

alter table
cust_table
add
cust_sex varchar2(1) NOT NULL;

Her is an example of Oracle "alter table" syntax to add multiple data columns.

ALTER TABLE
cust_table
ADD
(
cust_sex char(1) NOT NULL,
cust_credit_rating number
);

This entry was posted on 6:44 PM . You can leave a response and follow any responses to this entry through the Subscribe to: Post Comments (Atom) .

0 comments

Newer Post Older Post