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
22519 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 a sql select statement?

1042

How do I find sql profiler?

947

Mention what plvcmt and plvrb does in pl/sql?

1144

What is the difference between the conventional and direct path loader? : aql loader

1157

How many row comparison operators are used while working with a subquery?

1036

What is multiple columns?

1075

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

What is not in sql?

952

What is attribute indicator in pl sql?

1017

how to include numeric values in sql statements? : Sql dba

1104

How to Declare Fixed Length String Value In PL SQL

1158

Explain select statements in sql?

1061

Are pl sql variables case sensitive?

1053

What version is sql?

1039

What do you mean by dbms? What are its different types?

1020