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
- 22357 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 sql*loader?
Will truncate release space?
What are the advantages of pl sql over sql?
how to enter characters as hex numbers? : Sql dba
what is collation? : Sql dba
What is type and rowtype in pl sql?
What is union and union all keyword in sql and what are their differences?
Can we join same table in sql?
What is difference between stored procedure and trigger?
Is it possible to sort a column using a column alias?
What are sql data types?
what are the properties and different types of sub-queries? : Sql dba
which tcp/ip port does sql server run on? : Sql dba
What are variables in pl sql?
how to get help information from the server? : Sql dba
