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
22848 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 are the types of variables use in pl sql?

1092

What are the types of index in sql?

1120

How many primary keys can a table have?

1058

what are different types of keys in sql?

1219

What are synonyms in sql?

1019

Can we use pl sql in mysql?

1063

when is the use of update_statistics command? : Sql dba

1099

What are pl/sql cursors?

1101

Can we join two tables without common column?

1060

How do you explain an index?

1331

What is multiple partition?

1019

Mention what are different methods to trace the pl/sql code?

1296

what is uncommittable transactions? : Transact sql

1038

How many types of triggers exist in pl/sql?

1134

How do you write a complex sql query?

1142