alter table <table name> modify (columnname newdatatype (size))

what is the syntax of ALTER command?

Question Posted / sridevi

Answer Posted / sridevi

alter table <table name> modify (columnname newdatatype
(size))

Is This Answer Correct ?

18 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is a connect identifier?

1042

What is meant by raw datatype?

1062

How to use "while" statements in oracle?

1327

Can we commit inside a function in oracle?

967

How to apply filtering criteria at group level in oracle?

1045

How to use subqueries with the in operator using oracle?

1091

What are the different pseudo commands? Explain in general?

1080

Explain the use of grant option in imp command.

1030

How can Oracle users be audited?

1118

What is recovery manager(rman) backup in Oracle?

1185

How to call a sub procedure?

1098

What are the parameters that we can pass through a stored procedure?

1067

What are the ways tablespaces can be managed and how do they differ?

2369

How to use existing values in update statements using oracle?

1069

What are joins, explain all types of joins?

2299