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

how to get help information from the server? : Sql dba

919

What are user defined functions?

994

Can a composite key be null?

959

What are the commands used in sql?

1047

When to use inner join and left join?

937

What is dbo in sql?

941

What are system versioned tables?

1010

What is rank () in sql?

926

What are the advantages of normalization?

1067

What is the current version of sql?

1004

What are the different set operators available in sql?

1009

How do you exit in sql?

1096

how to include character strings in sql statements? : Sql dba

1047

What is full form of rtm?

990

Write a query to find the names of users that begin with "um" in sql?

972