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
22356 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 to download oracle sql developer?

1087

What is a dynamic query?

1010

How do I view an execution plan in sql?

970

What is autocommit sql?

972

How do I create a memory optimized filegroup?

948

What is your daily office routine?

2257

What is rownum and rowid?

1020

What type of database is cloud sql?

1084

what are all the common sql function? : Sql dba

1048

What is the difference between sql, mysql and sql server?

1069

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1051

What are two statement types in sql?

1067

What are different categories of sql commands?

1117

What is trigger types of trigger?

1052

Can a table contain multiple foreign key’s?

984