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

How to write date and time literals in oracle?

958

What are the various oracle database objects?

1099

What is an index associated with a constraint?

983

How to select all columns of all rows from a table in oracle?

1005

Can sub procedure/function be called recursively?

952

What is the difference between post-database commit and post-form commit?

1120

What is archive log in Oracle?

1078

Differentiate between pre-select and pre-query?

1059

How many categories of data types?

944

Difference between inner join vs where ?

987

How do you find current date and time in oracle?

995

How to use existing values in update statements using oracle?

1020

Explain integrity constraints?

1066

What is SQL access advisor in Oracle?

1148

What are dml statements in oracle?

1050