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
22489 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

What is the function that is used to transfer a pl/sql table log to a database table?

1023

Can pl sql procedure have a return statement?

1031

Do foreign keys improve performance?

1026

Could you please provide oca (oracle 10g) dumps for my certification ?

5169

What does partition by mean in sql?

963

how to get a list of all tables in a database? : Sql dba

977

What mean sql?

1014

What is the difference between alter trigger and drop trigger statements?

1110

What is view? Can we update view

1440

Why does sql need a server?

1044

What is mutating trigger?

1024

What version is sql?

1035

What are triggers and its uses?

1047

Why self join is used in sql?

977

What is number function in sql?

976