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.
Answers were Sorted based on User's Feedback
Answer / rinson
It will raise error ora-1439 column to be modifiedy must be
empty to change datatype.
Is This Answer Correct ? | 26 Yes | 2 No |
Answer / subbarayulu
It Will not work properly. when ever the table with data
user can't chage the column's datatype. It allows to
increase the size of the data type only.
Is This Answer Correct ? | 14 Yes | 2 No |
Answer / imran
It wo'nt work because if there is an data exist in
(id number(9)).You cannot modify if colmun is not empty.
Is This Answer Correct ? | 15 Yes | 5 No |
Answer / sathish p
We cant change column datatype while the column having
values.. Bcos error will come when u run the Alter table
modify statement...
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / ramesh
It will work 100%.
becos. we are increasing the length. if we are decreasing
the length then it gives error.
Is This Answer Correct ? | 3 Yes | 0 No |
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 |
Answer / 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 |
Answer / shailesh j
If column contains data then we can only modify size of
column without changing its data type. But if the column is
empty then we can modify its size as well data type.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / reddi
It won't work coz number can't datatype can't be changed to
varchar. If data does not exits then its work fine.
Is This Answer Correct ? | 2 Yes | 2 No |
What is sql*loader?
Is full outer join same as cross join?
How many LONG columns are allowed in a table?
1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....
Why do we use sql constraints? Which constraints we can use while creating database in sql?
what is julian date in oracle
Why triggers are used?
Is pl sql a scripting language?
Why does %isopen return false for an implicit cursor?
what is “go” in t-sql? : Transact sql
Can we alter stored procedure?
what is an associative array with example?