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

definition of cluster and non-clustered index?

2959

How to test null values?

1041

What is a tns file?

938

How to check the server version in oracle?

1032

What is the relation of a user account and a schema?

1062

What are the different oracle database objects?

1030

What is catalog in Oracle?

1264

How to assign query results to variables?

1011

Please explain joins in oracle?

1008

Oracle

2319

What are the limitations of check constraint?

963

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4292

What is the recommended interval at which to run statspack snapshots, and why?

2860

Can a formula column be obtained through a select statement ?

2264

What is a cursor variable?

1044