There should be error raised as below ORA-01439: column to be modified mus

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

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

Answer Posted / lakshmanakumar

There should be error raised as below
ORA-01439: column to be modified must be empty to change
datatype

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

935

How do you use collections in procedure to return the resultset?

2229

What are the usages of sql?

1047

Can a select statement fire a trigger?

1141

What is foreign key and example?

917

what is sql in mysql? : Sql dba

1176

What are literals in sql server?

1140

Is sql port 1433 encrypted?

1010

How do I upgrade sql?

987

What is the starting oracle error number? What is meant by forward declaration in functions?

972

Explain what is a database?

1073

What is the usage of when clause in trigger?

1032

How does a trigger work?

1043

What are the built in functions of sql?

1015

What is the difference between having clause and where clause?

1046