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
21963 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 the two types of cursors in pl sql?

1001

What is difference between nchar and nvarchar?

953

What is the process of debugging?

1000

how to use like conditions? : Sql dba

1036

What does stand for in sql?

915

How does cross join work in sql?

955

Why is pl sql used?

934

What is a null value?

1080

How to avoid using cursors?

1035

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

953

What is blind sql injection?

990

How do you pronounce sql?

952

Can we rollback truncate?

940

Is there a 64 bit version of ssms?

893

Do ddl statements need commit?

921