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
22340 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 happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1021

what is the difference between blob and text? : Sql dba

1003

What are database links used for?

1029

Is truncate ddl or dml?

976

How exception handling is done in advance pl/sql?

965

What is the difference between union and union all command?

1061

What is the difference between execution of triggers and stored procedures?

1099

How much does sqlite cost?

1024

what are the advantages a stored procedure? : Sql dba

962

What are the syntax and use of the coalesce function?

1182

Can we create view in stored procedure?

944

How do I create a sql database?

979

What is a database event trigger?

1137

What do you mean by rowid?

953

What does count (*) do in sql?

983