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
22333 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

How do you write an index?

949

Can we use pl sql in mysql?

997

What are the differences between in and exists clause?

1091

What is a table partition?

1106

What is using in sql?

1063

Can a table contain multiple foreign key’s?

983

Is trigger a stored procedure?

922

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1009

What is compound trigger?

1016

Explain the difference between 'between' & 'and' operators in sql

981

Why we use cross join?

938

What is clustered index sql?

972

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

947

Is t sql a programming language?

1049

explain what is mysql? : Sql dba

1065