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
22917 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 set up sql*plus output format in oracle?

1090

What is where clause in sql?

1092

What is the best partition size for windows 10?

1063

Why stored procedure is faster than query?

1170

Is natural join and inner join same?

1000

What is sql resultset?

1045

what is transaction? : Sql dba

1072

Is sql a programming?

1033

What's the procedure?

988

how to fetch common records from two tables? : Sql dba

1260

What are the parts of a sql statement?

1156

What is recursive stored procedure?

1147

What are the advantages of sql? Explain

1163

how to do backup entire database? : Transact sql

1200

Can we commit inside a trigger?

1056