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

Explain the use of analyse option in exp command.

1076

What is the difference between PFILE and SPFILE in Oracle?

1002

What do you mean by cdb and pdb in oracle 12c?

1014

What is a user role in oracle?

1075

Explain oracle instance.

1118

How to pass a cursor variable to a procedure?

1052

How to delete a column in an existing table in oracle?

1023

How to connect the oracle server as sysdba?

1023

What is the meaning of recursive hints in oracle?

1002

How would you change old and new values in an insert, delete and update triggers?

961

What do you mean by a database transaction & what all tcl statements are available in oracle?

939

how to make an oracle object

2303

what is the scenario where you take the database to NoArchivelog mode?

2272

What is a cursor variable?

1055

When do you get a .pll extension in oracle? Explain its importance

993