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
- 18476 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / abhishekjaiswal
They are asking change datatype from number to varchar2..So it is not possible if table have data..this will give error 'ORA-01439: column to be modified must be empty to change datatype'.You can alter table and modify that column in same data type.
See Example
select * from a;
N F
----- -------------------
5
1
3
alter table a modify (n varchar2(10))
*
ERROR at line 1:
ORA-01439: column to be modified must be empty to change datatype
1* alter table a modify (n number)
SQL> /
Table altered.<<<<<<<<<<<<<<<<<
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a temporal table?
Is it possible to read/write files to-and-from PL/SQL?
How many types of keys are there in sql?
What is audit logout in sql profiler?
what is a stored procedure? : Sql dba
What are the ways on commenting in a pl/sql code?
what is the difference between delete and truncate statement in sql? : Sql dba
Can we call procedure in select statement?
What are expressions?
What are % type and % rowtype?
What problem one might face while writing log information to a data-base table in pl/sql?
What are different types of triggers?
what are the different type of normalization? : Sql dba
Write a query to find the names of users that begin with "um" in sql?
Does sql*plus have a pl/sql engine?
