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

How do you update f as m and m as f from the below table testtable?

1858

How can a function retun more than one value in oracle with proper example?

1074

what is isam? : Sql dba

1009

What is application trigger?

1001

What does joining a thread mean?

1021

Can a procedure in a package be overloaded?

1045

what is 'mysqladmin' in mysql? : Sql dba

1026

What is the use of <> sql?

980

what is self join and what is the requirement of self join? : Sql dba

1145

What is pl sql record in oracle?

1035

What is the difference between a subquery and a join?

1108

What do you know by pl/sql cursors?

1105

How is pl sql different from sql?

1093

Can there be more than one function with a similar name in a pl/sql block?

985

Are sql database names case sensitive?

1006