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
22839 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 is exception handling handled in mysql? : Sql dba

1128

What are the types of variable use in pl sql?

1136

Cite the differences between execution of triggers and stored procedures?

1138

what is the use of set statement in tsql? : Transact sql

1059

What is %s in sql?

1075

Which is better cte or subquery?

1076

How to get unique records from a table?

1021

What is cost in sql execution plan?

1043

What is bitemporal narrowing?

1370

What program will open a mdb file?

1019

Why do we use subquery?

1074

Is nosql relational?

999

What are the two types of periodical indexes?

987

how to use 'mysql' to run sql statements? : Sql dba

1119

What is sql*loader and what is it used for?

1218