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
22941 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 are all different types of collation sensitivity?

1088

How to run sql functions in pl/sql?

1132

Is it possible to sort a column using a column alias?

1109

What is the usage of when clause in trigger?

1101

what is union? : Sql dba

1086

What is sql character function?

1160

Explain lock escalation? : Transact sql

1291

what are the authentication modes in sql server? : Sql dba

1134

What is sql engine in oracle?

1051

Can we join two tables without common column?

1070

What is the use of function in sql?

1158

What is varray in pl sql?

1131

Is stored procedure faster than query?

1028

What are different types of keys?

1183

What are the different datatypes available in PL/SQL?

1163