There should be error raised as below ORA-01439: column to be modified mus

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

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

Answer Posted / lakshmanakumar

There should be error raised as below
ORA-01439: column to be modified must be empty to change
datatype

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is join and inner join the same?

1055

Why use subqueries instead of joins?

1142

What is cross join sql?

966

Is sql better than excel?

1238

how to use in conditions? : Sql dba

1069

what are the advantages of using stored procedures? : Sql dba

1162

Is primary key always clustered index?

1075

Is natural join and inner join same?

1000

What is sql used for?

1173

Why plvtab is considered as the easiest way to access the pl/sql table?

1300

How to use distinct and count in sql query? Explain

1088

Which constraints we can use while creating database in sql?

1132

Which one is better sql or oracle?

1020

Can there be more than one function with a similar name in a pl/sql block?

1046

Can we commit in trigger?

1031