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
- 18557 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / nzabin
SQL Error: ORA-01439: column to be modified must be empty to change datatype
01439. 00000 - "column to be modified must be empty to change datatype"
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of functions in sql?
What is type and rowtype in pl sql?
How do you write an index?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What does (*) mean in sql?
Which is faster subquery or join?
How global cursor can be declare with dynamic trigger ?
what does myisamchk do? : Sql dba
Difference between truncate, delete and drop commands?
what are the 'mysql' command line arguments? : Sql dba
What are the two virtual tables available at the time of database trigger execution?
Can unique keys be null?
What does an inner join do?
What is the clause we need to add in function body to return variable?
What is the difference between having clause and where clause?
