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
- 20335 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
Which is better varchar or nvarchar?
What is on delete set null?
What is the difference between delete and truncate statement in sql?
Is pl sql still used?
What is the use of stored procedures?
What is meant by temporal data?
Explain character-manipulation functions?
How many tables can a sql database have?
What is exit statement?
What is crud diagram?
How do you rank data in sql?
Why do we use sqlite?
What is indexing oracle sql?
what is self join and what is the requirement of self join? : Sql dba
What are schema-level triggers?
