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 the difference between view and materialized view in Oracle?

1098

What do you mean by redo log file mirroring?

983

What are the oracle built-in data types?

1021

What are the predefined tablespaces in a database?

1018

How to run the anonymous block again?

1072

Which are the five query types available in oracle?

911

What is an Oracle Instance?

1079

What happens if the update subquery returns multiple rows?

1058

is there a tool to trace queries, like profiler for sql server?

1090

how do u setup a replication site?

1937

What is oracle analytical function?

1047

Why do we need integrity constraints in a database?

981

How to select some columns from a table in oracle?

1013

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2259

How to rename an index?

1011