Oracle “Alter Table” add Column

============================================
By Mohd Izzairi Yamin
============================================
First of all if you have a table and you want to add more fields you should use alter table.

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

Example 1 using alter table if you want to add 1 field

alter table
xyiry_login
add
login_day  varchar2(12) NOT NULL;

Example 2 using alter table if you want to add more than 1 field

ALTER TABLE
xyiry_login
ADD
(
login_day  varchar2(12) NOT NULL,
count_login   number
);

About this entry

You’re currently reading “Oracle “Alter Table” add Column,” an entry on Xyiry PHP Blog | Where Open Source Lives

Published:
08.20.07 / 9am
Category:
Oracle