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
22338 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 the most common sql injection tool?

1027

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

985

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3557

How do I make my sql query run faster?

919

Can you inner join the same table?

978

What is the difference between delete, truncate and drop command?

1126

What are the built in functions of sql?

1015

Show how functions and procedures are called in a pl/sql block.

1101

Explain the steps needed to create the scheduled job?

1023

What is rank () in sql?

926

Why do we need databases?

1024

What is a field in a database?

1048

What is the difference between the implicit and explicit cursors?

1034

What is data control language (dcl)?

1114

How do I write a sql query in pgadmin 4?

962