If column contains data then we can only modify size of column without ch

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 / shailesh j

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

Answer Posted / shailesh j

If column contains data then we can only modify size of
column without changing its data type. But if the column is
empty then we can modify its size as well data type.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the maximum size of sqlite database?

1040

What is record variable?

922

What is the difference between local and global temporary table?

987

what is foreign key? : Sql dba

969

What is consistency?

1060

explain access control lists. : Sql dba

946

What is information schema in sql?

1012

What are the most important ddl statements in sql?

1024

When you have to use a default "rollback to" savepoint of plvlog?

1123

What is full join?

896

What is sql integrity?

1060

What are the different parts of a package?

1041

Is oracel sql developer written in java?

1058

What is trigger in pl sql?

955

What are the various restrictions imposed on view in terms of dml?

909