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
22894 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 sql and its types?

1263

How delete all data from all tables in sql?

994

What is clustered and nonclustered index in sql?

988

How to look at the current sql*plus system settings?

1225

Can a table contain multiple primary key’s?

1163

How do I quit sql?

1009

What is the command used to fetch the first 5 characters of a string?

1262

How many scalar data types are supported in pl/sql?

1112

Why select is used in sql?

1075

Does oracle roll back the transaction on an error?

1074

what is a database lock ? : Sql dba

1229

how to include comments in sql statements? : Sql dba

1003

Why primary key is required?

1054

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2554

How many sql are there?

1055