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
22493 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 to enter numeric values as hex numbers? : Sql dba

1065

What is cte?

983

Can ddl statements be used in pl/sql?

1145

what is view? : Sql dba

962

What is hibernate and its relation to sql?

1124

How to move files from one directory to another in pl sql?

1196

Why do we use view in sql?

965

Is sql a case sensitive language?

948

What is %type in sql?

969

Which is better join or subquery?

1137

What is sqlservr exe?

979

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1104

What is varchar used for?

1082

What is pl sql record in oracle?

1036

What is identity column in sql server?

1049