Create table emp (id number(9), name varchar2(20),salary number

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 / guru

13 Answers
22537 Views
Oracle, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table..

Answer / 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

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table..

Answer / nilesh

It will not work,

If u have data in a table and u have to change data type
number to varchar2 then it will gives error, If u change
varchar2(100) column to char(200) it will work,
The number to varchar2 or varchar2 to number will not work
when u have data in table.

Is This Answer Correct ?

0 Yes

2 No

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table..

Answer / tajuddin

It will work your query 100% will work

Chers
Taj

Is This Answer Correct ?

9 Yes

16 No

Post New Answer