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
21965 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 we use pl sql in sql server?

1010

How do you modify a trigger?

874

What are aggregate functions in sql?

1087

Can you selectively load only those records that you need? : aql loader

983

Why do we need unique key in a table?

882

What is snowflake sql?

1010

What is left join in postgresql?

993

how to convert dates to character strings? : Sql dba

1069

What are the different types of tables in sql?

926

Can 2 queries be executed simultaneously in a distributed database system?

1079

Name some usages of database trigger?

963

What is the reports view in oracle sql developer?

924

What is integrity in sql?

979

what are the different type of normalization? : Sql dba

968

How to prepare for oracle pl sql certification?

1008