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
- 21991 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
define sql update statement ? : Sql dba
how to fetch alternate records from a table? : Sql dba
Explain about various levels of constraint.
Define commit, rollback and savepoint?
how to analyze tables with 'mysqlcheck'? : Sql dba
What does count (*) mean in sql?
What is the advantage of index in sql?
What are the uses of merge?
What is the order of sql select?
what is the use of friend function? : Sql dba
Who developed sql?
how to use 'mysql' to run sql statements? : Sql dba
What are the steps for performance tuning.
How to raise user-defined exception with custom sqlerrm ?
What does sql stand for?
