It will raise error ora-1439 column to be modifiedy must be empty to chang

Create table emp
(id number(9), name varchar2(20),salary
number(9,2));
The table has 100 records after table created.Now i nee to
change id's Datatype is to be Varchar2(15). now

Alter table emp modify(id varchar2(15),name varchar2(20),
salary number(9,2));

Whether it will work or returns error? post answer with
explanation.

Question Posted / rinson

13 Answers
22563 Views
Oracle, TCS, I also Faced
E-Mail Answers

Answer Posted / rinson

It will raise error ora-1439 column to be modifiedy must be
empty to change datatype.

Is This Answer Correct ?

26 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can sql function call stored procedure?

1033

What is program debugging?

1260

what is a relationship and what are they? : Sql dba

1112

how would you enter characters as hex numbers? : Sql dba

995

What is over () in sql?

973

List the various privileges that a user can grant to another user?

1053

What is the difference between sql and mysql?

1129

Does sql*plus also have a pl/sql engine?

1087

What is a mutating table and a constraining table?

1123

what is union, minus and interact commands? : Sql dba

1197

Is join and inner join the same?

1016

Which is faster view or stored procedure?

952

Can we perform dml in function?

1078

When do we use triggers?

1091

What is %type in sql?

973