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

What is pl sql in oracle?

1041

What are the different sql commands?

1073

Why do we use view in sql?

961

How do you rank data in sql?

1005

What is data definition language?

1092

what is table? : Sql dba

1062

What does <> sql mean?

1089

What are different clauses used in sql?

1115

What is an alias command?

1068

Explain the uses of a database trigger?

1043

What are the different types of tables in sql?

1009

Is sql microsoft?

1054

What does trigger mean in slang?

1054

What is restrict in sql?

1115

what is the difference difference between procedure and packages

10407