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
22520 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 is the difference between the sql*loader and import utilities? : aql loader

1047

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1022

Are stored procedures faster than dynamic sql?

1047

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1138

How do I access sql anywhere database?

973

Difference between global and parameter variables?

1972

How to combine two stored procedures in sql?

1242

Is primary key an index?

998

What is sql*plus?

1084

what is the use of double ampersand (&&) in sql queries?

1178

What is vector point function?

1057

What is nvarchar in sql?

928

How does a self join work?

1132

What is an intersect?

1110

How to load data with sql*loader?

1054