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

How many times can we commit in a loop?

1069

How do I run a program in pl sql?

1059

Can sql developer connect to db2?

1106

What is pivot in sql?

976

How to fetch alternate records from a table?

1310

What is 19 null in sql?

1032

Can we rollback after truncate?

1079

Does truncate table reset auto increment?

1056

What is the best partition size for windows 10?

1063

How many sql commands are there?

1165

what is a database lock ? : Sql dba

1229

Are pl sql variables case sensitive?

1097

How to create your own reports in sql developer?

1068

what is a primary key? : Sql dba

1089

What are few of the schema objects that are created using PL/SQL?

1089