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
- 18466 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is left join faster than inner join?
Write a unique difference between a function and a stored procedure.
What is index example?
What are the benefits of pl sql?
Can we insert in view in sql?
What does rownum mean in sql?
what is the difference between primary key and unique key? : Sql dba
Do prepared statements prevent sql injection?
What is the difference between sum and count in sql?
How to look at the current sql*plus system settings?
What is pl sql commands?
How to process query result in pl/sql?
What are conditional predicates?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What are the two different parts of the pl/sql packages?
