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
22483 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

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

998

What is optimistic concurrency control? : Transact sql

984

What is cross join example?

1004

Explain lock escalation? : Transact sql

1197

what is the difference between clustered and non clustered index in sql? : Sql dba

1127

how to extract a unit value from a date and time? : Sql dba

990

Is record in pl sql?

972

How do I copy a table in sql?

988

How many sql statements are used?

1010

what is isam? : Sql dba

1008

What is db journal file?

1065

Is inner join same as self join?

1116

What is full join in sql?

991

What is the usage of the distinct keyword?

1220

Explain what is rdbms?

1035