Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 21995 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
Can we debug stored procedure?
how to use case expression? : Sql dba
Could you please provide oca (oracle 10g) dumps for my certification ?
Why left join is used in sql?
How do I tune a sql query?
Which normal form is best?
What is normalisation and its types?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
How do you concatenate in sql?
What do you mean by stored procedures? How do we use it?
what is meant by urlencode and urldocode? : Sql dba
How do I save a sql query?
What are operators available in sql?
Is trigger a stored procedure?
List the various privileges that a user can grant to another user?
