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
22907 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 date and time data types? : Sql dba

1031

What is sql*loader?

1296

Is there a way to automate sql execution from the command-line, batch job or shell script?

1023

what does the t-sql command ident_incr does? : Transact sql

1127

What is a sql select statement?

1084

Explain 3 basic parts of a trigger.

1379

What is Histogram?

1616

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

1054

How do I clear the screen in sql plus?

1091

What is synchronized subquery?

1226

How do you update a value in sql?

1105

What operating systems are supported by oracle sql developer?

1020

is it possible to pass an object or table to a procedure as an argument?

1188

Which is faster view or stored procedure?

1012

Does sql*plus have a pl/sql engine?

1138