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

explain advantages of myisam over innodb? : Sql dba

1014

What is multiple columns?

1000

What is trigger explain with example?

977

Is progress software supports to ( pl/sql )?

968

Mention what plvcmt and plvrb does in pl/sql?

1061

Is it possible to create startup or shutdown trigger for on-schema?

977

What is scalar data type in pl sql?

1018

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1083

What are % type and % rowtype?

977

What is AUTH_ID and AUTH_USER in pl/sql ?

2134

How do I truncate a word?

986

What is difference between cursor and trigger?

1015

What are the advantages of stored procedure?

945

What is parameter substitution in sql?

975

What is function and procedure in pl sql?

967