We cant change column datatype while the column having values.. Bcos error

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 / sathish p

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

Answer Posted / sathish p

We cant change column datatype while the column having
values.. Bcos error will come when u run the Alter table
modify statement...

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the ddl commands?

948

Can a table contain multiple foreign key’s?

948

Is delete faster than truncate?

957

What is an intersect?

1045

Can we create view in stored procedure?

909

What is clause?

1063

What is server name sql?

1068

How subquery works in sql?

994

What is an emotional trigger?

930

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

900

What is loop in pl sql?

981

Are subqueries faster than joins?

949

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

969

What is mutating error?

907

What is the difference between drop and truncate commands?

997