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

What can sql server reporting services do?

1096

how to install mysql? : Sql dba

1091

Write a query to find the names of users that begin with "um" in sql?

972

What is a trigger in sql?

1192

What does rownum mean in sql?

1011

What are the different types of dbmss?

999

How to sort the rows in sql.

1050

What are inner and outer joins examples of both?

940

Is sqlite free?

950

How can a function retun more than one value in oracle with proper example?

1061

Can we insert data in view?

948

What is pls integer?

1017

How much does a sql dba make? : SQL DBA

928

Give the order of sql select?

1120

How many commands are there in sql?

1010