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

what is the syntax of ALTER command?

Question Posted / suri

Answer Posted / suri

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why oracle is used?

991

Can I create users through internet explorer in oracle 10g?

1015

How to convert a date to char in oracle? Give one example.

1000

What do you mean by group by clause?

977

how the indexes are stored in the Oracle Database?

2212

What are advantages of dateset in datastage?

2197

What happens if the update subquery returns multiple rows?

1037

What is oracle server autotrace in oracle?

1088

What is null value in oracle?

1031

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

2503

What is literal?

953

Explain the use of ignore option in imp command.

972

How are extents allocated to a segment?

1057

How to resolve the ORA-39133 error in Oracle?

1029

Can the query output be sorted by multiple columns in oracle?

933