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

what is the syntax of ALTER command?

Question Posted / rajini

Answer Posted / rajini

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

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What would you do with an in-doubt distributed transaction?

1972

How to resolve name conflicts between variables and columns?

1015

How do we represent comments in oracle?

1041

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2546

Explain the difference between sap and oracle?

1027

How to start a new transaction in oracle?

1077

What is a sub query? Describe its types?

1011

What is a cognitive schema?

955

What are the execution control statements in oracle?

1081

11. Display the client number and name and the client number and name of the person who referred that client.

2329

How to filter out duplications in the returning rows using oracle?

1014

What is a lookup table in oracle?

965

Will you be able to store pictures in the database?

1107

What are the general rules on data consistency?

1003

How to shutdown your 10g xe server from command line?

1080