It will raise error ora-1439 column to be modifiedy must be empty to chang

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

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

Answer Posted / rinson

It will raise error ora-1439 column to be modifiedy must be
empty to change datatype.

Is This Answer Correct ?

26 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which tcp/ip port does sql server run?

1070

what is denormalization. : Sql dba

1169

How do I view tables in mysql?

1045

what are dynamic queries in t-sql? : Transact sql

1072

What are the advantages of sql?

1108

Is it mandatory for the primary key to be given a value when a new record is inserted?

1261

How do you explain an index number?

1190

What are different types of statements supported by sql?

1225

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1020

How to rename a column in the output of sql query?

1147

What are the rules to be applied to nulls whilst doing comparisons?

1373

what is sql profiler? : Sql dba

1122

What are the different ddl commands in sql?

1260

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1062

How do you take the union of two tables in sql?

1040