SQL Error: ORA-01439: column to be modified must be empty to change datatyp

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 / nzabin

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

Answer Posted / nzabin

SQL Error: ORA-01439: column to be modified must be empty to change datatype
01439. 00000 - "column to be modified must be empty to change datatype"

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is varchar used for?

1025

Describe sql comments?

963

What is data type in database?

933

Is natural join and inner join same?

855

What are all the different normalization?

979

what are myisam tables? : Sql dba

956

What is difference between sql and oracle?

1050

What is an escape character in sql?

983

What are conditional predicates?

990

how to run 'mysql' commands from a batch file? : Sql dba

1063

What is the difference between between and in condition operators?

940

How does one load ebcdic data? : aql loader

1095

How do I start pl sql?

899

What plvcmt and plvrb does in pl/sql?

1251

What is difference between sql function and stored procedure?

944