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
22482 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 the purpose of the primary key?

1063

Which table is left in join?

978

how to create a new table in mysql? : Sql dba

986

What is difference between db2 and sql?

999

What is the difference between clustered and non-clustered index in sql?

1015

Define commit?

1003

What is lookup table in sql?

1048

How do I run a sql query?

1017

How do you optimize a stored procedure in sql?

957

How to rename a table?

1020

Is it possible to create startup or shutdown trigger for on-schema?

1029

explain primary keys and auto increment fields in mysql : sql dba

977

what is meant by urlencode and urldocode? : Sql dba

1176

How do you update a table in sql?

988

What is the location of pre_defined_functions.

1166