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

how do you tune the slow running queries in oracle db , explain the methodology

2814

What is use of term?

1068

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

961

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

975

what are the difference between clustered and a non-clustered index? : Sql dba

1033

Explain the uses of database trigger.

1118

what is denormalization. : Sql dba

1117

Can we delete column in sql?

1103

What are different functions in sql?

951

What is a join?

1072

Why is sql*loader direct path so fast?

1108

what is query cache in mysql? : Sql dba

1041

Is oracel sql developer written in java?

1114

What is percent sign in sql?

1285

What is a sql select statement?

1042