It Will not work properly. when ever the table with data user can't

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

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

Answer Posted / subbarayulu

It Will not work properly. when ever the table with data
user can't chage the column's datatype. It allows to
increase the size of the data type only.

Is This Answer Correct ?

14 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the key differences between SQL and PL SQL?

1291

What are the different types of joins in sql?

1926

Explain the insert into statements in sql?

1061

What are the 3 types of behavioral triggers?

1327

Can function return multiple values in sql?

1106

How do we accept inputs from user during runtime?

1126

How do I run sql?

1264

Explain lock escalation? : Transact sql

1289

How do I make sql search faster?

1048

How do I install sql?

1053

What are the uses of sysdate and user keywords?

1161

Is primary key always clustered index?

1075

Explain the the update statement in sql?

1108

how to rename an existing table in mysql? : Sql dba

1129

What is a database? Explain

1191