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.
- 13 Answers
- 20290 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
How global cursor can be declare with dynamic trigger ?
What are the differences between in and exists clause?
How to get unique records from a table?
What is the syntax and use of the coalesce function?
what happens if you no create privilege in a database? : Sql dba
Does google use sql?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What are the limitations of sql express?
Are views faster than queries?
What is embedded sql in db2?
Which sql statement is used to return only different values?
How to know the last executed procedure?
What is auto increment?
Explain the uses of a database trigger?
What is coalesce in sql?
