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 mutating triggers.

1088

How to retrieve data from an cursor to a record?

1158

What is the difference between sharding and partitioning?

1040

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

1200

What suggestions do you have to reduce the network traffic?

1020

What happens to the data files if a tablespace is dropped?

1107

Explain self joins in oracle?

1063

What happens to the current transaction if the session is ended?

1136

How translate command is different from replace?

1142

How to define an oracle sub procedure?

1232

What is MTTR advisor in Oracle?

1141

Explain oracle’s system global area (sga).

1189

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2170

Is primary key indexed by default in oracle?

1049

What are ddl statements in oracle?

1131