It won't work coz number can't datatype can't be changed to

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

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

Answer Posted / reddi

It won't work coz number can't datatype can't be changed to
varchar. If data does not exits then its work fine.

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is string data type in sql?

1046

What is bitemporal narrowing?

1231

What are the types of functions in sql?

965

What do you understand by case manipulation functions?

951

how to include comments in sql statements? : Sql dba

909

How do I create a memory optimized filegroup?

903

Why do we use joins in sql?

907

What is the use of pl/sql table?

996

which operator is used in query for pattern matching? : Sql dba

946

What is dml and ddl?

897

What is mutating trigger?

966

Which function is used to return remainder in a division operator in sql?

1073

Which one is better sql or oracle?

899

What is a table in a database?

986

What is a behavioral trigger?

925