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
- 20326 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
What is a rank in sql?
Can we create table in function?
how would you get the current date in mysql? : Sql dba
How can I change database name in sql?
What is a primary key called that is made up of more than one field?
What is index example?
How many joins in sql?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is the use of function in sql?
Define commit, rollback and savepoint?
What are different joins used in sql?
What is schema in sql?
Can we connect to postgresql using sql developer?
What will you get by the cursor attribute sql%notfound?
How many sql are there?
