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

Can we use having without group by in sql?

1051

How do you delete data from a table?

1099

How do I view a view in sql?

994

What is type and rowtype in pl sql?

1057

What are the different set operators available in sql?

1080

What is sql injection vulnerability?

1005

what is row? : Sql dba

1277

what are the advantages and disadvantages of views in a database? : Sql dba

1074

what are the properties and different types of sub-queries? : Sql dba

1075

Explain the order of sql statement execution?

1088

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1302

what is sql profiler? : Sql dba

1115

What is transaction control language (tcl)?

1186

Does user triggers have entry for trigger with compilation errors?

1091

What has stored procedures in sql?

1104