It will not work, If u have data in a table and u have to change data ty

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

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

Answer Posted / nilesh

It will not work,

If u have data in a table and u have to change data type
number to varchar2 then it will gives error, If u change
varchar2(100) column to char(200) it will work,
The number to varchar2 or varchar2 to number will not work
when u have data in table.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why we use join in sql?

917

What is rtm in testing?

1040

how to increment dates by 1 in mysql? : Sql dba

928

What is dialect in sql?

890

Is full outer join same as cross join?

915

what is the difference between myisam static and myisam dynamic? : Sql dba

1003

Is pl sql better than sql?

982

What is sql keyword?

946

Why does sql need a server?

992

How to rename a table?

959

does sql support programming? : Sql dba

993

What are the basic sql commands?

1039

Mention what pl/sql package consists of?

939

What is identity column in sql server?

988

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

950