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

what is the syntax of ALTER command?

Question Posted / guest

Answer Posted / guest

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

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1895

How to omit columns with default values in insert statement in oracle?

996

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1996

What is Library Cache in Oracle?

1075

what is normalisation?what are its uses?

2207

What is bulk copy or bcp in oracle?

1044

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1010

What is oracle used for?

968

What is oracle thin client?

973

What is oracle data type?

901

How data locks are respected in oracle?

1009

How can we force the database to use the user specified rollback segment?

1065

Explain the different normalization forms?

1009

What are the extensions used by oracle reports?

995

What is background process in Oracle?

1050