It Will not work properly. when ever the table with data user can't

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 / subbarayulu

13 Answers
22495 Views
Oracle, TCS, I also Faced
E-Mail Answers

Answer Posted / subbarayulu

It Will not work properly. when ever the table with data
user can't chage the column's datatype. It allows to
increase the size of the data type only.

Is This Answer Correct ?

14 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3050

What is the use of prepared statement?

1025

How to raise user-defined exception with custom sqlerrm ?

1130

How do I run sql?

1188

What are sql constraints?

1175

What is raid? How does it help storage of databases?

1087

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

1154

difference between anonymous blocks and sub-programs.

1138

how to rename an existing table in mysql? : Sql dba

1064

What is field delimiter?

1048

What is audit logout in sql profiler?

1026

What are the types of keys?

996

What is a sql trace file?

1031

Why we use sql profiler?

962

What is synchronized subquery?

1170