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
22841 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 sql queries used for?

1079

How many sql databases can you have on one server?

1152

Which query operators in sql is used for pattern matching?

1009

what are the different type of sql's statements ? : Sql dba

976

Explain architecture of sql server notification services?

1107

What is not null in sql?

1107

What are the different types of tables in sql?

1063

How can you fetch first 5 characters of the string?

1065

What does joining a thread mean?

1074

how to decrement dates by 1 in mysql? : Sql dba

1072

Can there be 2 primary keys in a table?

1042

How to avoid using cursors?

1175

What is the requirement of self-join?

1206

what is bcp? When is it used?

1180

What are the two virtual tables available at the time of database trigger execution?

1270