Answer / sridevi

alter table <table name> modify (columnname newdatatype
(size))

Answer / sridevi

alter table <tablename> add column(col.name(size))

Answer / rajini

alter table tablename add(colname datatype,colname1
datatype...);
alter table tablename modify(colname datatype,colname1
datatype..);

Answer / guest

alter table tablename add(col1 datatype,col2 datatype...);
alter table tablenamemodify(col1 datatype,col2 datatype..);

Answer / guest

alter table <table name> modify(column definition...);
alter table <table name> add(column definitions...);

Answer / guest

Alter table tablename(data types1,...datatypen)

Answer / suri

alter table tablename add(colname datatype,colname1
datatype...);
alter table tablename modify(colname datatype,colname1
datatype..);

Answer / sandeep

alter table <table_name> add column <Data type of the column>;

Give the Types of modules in a form?

1 Answers  

What is the meaning of recursive hints in oracle?

1 Answers  

what are the disadvantages of hierarchial database over RDBMS?

1 Answers   TCS,

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 Answers  

How data locks are respected in oracle?

1 Answers  

Explain oracle insert into command?

1 Answers  

Difference between pre-select and pre-query

1 Answers  

What is the difference between truncate & delete command?

1 Answers  

What is SYSTEM tablespace and When is it Created?

2 Answers  

difference between procedures and function?

7 Answers   IBM,

Is there any function in oracle similar like group_concat of mysql?

1 Answers  

What are the benefits of ordbms?

1 Answers