It wil not work

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

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

Answer Posted / krishna

It wil not work

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are character functions in sql?

938

Define join and name different types of joins?

1008

What is the difference between left join and right join?

942

what is a relationship and what are they? : Sql dba

1101

Do we need commit after truncate?

1079

Are stored procedures compiled?

919

Why is sql better than hql?

992

What is a unique constraint?

1073

What is not equal in sql?

1123

How do I edit a trigger in sql developer?

993

What is a full join?

983

What is the usage of nvl function?

1040

Can we use the cursor's to create the collection in PL/SQL?

1027

how to enter characters as hex numbers? : Sql dba

1041

What is out parameter used for eventhough return statement can also be used in pl/sql?

1077