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
22327 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 is the use of prepared statement?

995

How to make a copy values from one column to another in sql?

1021

where are cookies actually stored on the hard disk? : Sql dba

1015

Explain what is a database?

1072

What can I use instead of union in sql?

947

How can we avoid duplicating records in a query?

957

What is coalesce in sql?

1034

What does <> sql mean?

1058

How you improve the performance of sql*loader? : aql loader

997

Can you sum a count in sql?

985

Explain what is table in a database?

1045

What does data normalization mean?

941

What is inner join in sql?

1058

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

991

How to run sql statements through the web interface?

1020