It will work 100%. becos. we are increasing the length. if we are decreasi

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

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

Answer Posted / ramesh

It will work 100%.
becos. we are increasing the length. if we are decreasing
the length then it gives error.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is pivot in sql?

976

What is union and union all keyword in sql?

1128

What is pl sql record in oracle?

1098

Can triggers stop a dml statement from executing on a table?

1164

Why we use join in sql?

1035

What does the file extension accdb stand for?

1022

What are some emotional triggers?

1043

Is big data nosql?

1004

what is try_catch block in procedure

1821

Differentiate pl/sql and sql?

1140

Is progress software supports to ( pl/sql )?

1114

what tools available for managing mysql server? : Sql dba

1142

How many tables can a sql database have?

1037

What is the maximum number of triggers, you can apply on a single table?

1055

What is orm in sql?

1102