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

Can we join same table in sql?

1078

How many aggregate functions are available there in sql?

1024

What is pl sql package?

1078

How does one load ebcdic data? : aql loader

1264

What is an implicit commit?

1105

How delete a row in sql?

1049

What is trigger with example?

1183

Is trigger a stored procedure?

989

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1064

What is optimistic concurrency control? : Transact sql

1038

What is a natural join?

1151

How many joins in sql?

1063

How do I create a sql database?

1064

What is a pragma statement?

1345

what is a database? : Sql dba

1251