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
21974 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 are transaction and its controls?

967

Can you call pl/sql package functions from within a fast formula?

974

Can we write dml inside a function in sql server?

899

What is java sql drivermanager?

1020

Do prepared statements prevent sql injection?

897

what are set operators in sql? : Sql dba

983

Show the cursor attributes of pl/sql.

996

Which query operators in sql is used for pattern matching?

902

Why sql query is slow?

929

How can a function retun more than one value in oracle with proper example?

1026

What is on delete restrict?

941

How do you create a unique index?

989

How many types of primary keys are there?

977

How do I find duplicates in sql?

877

what is difference between delete and truncate commands? : Sql dba

1065