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
- 20312 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
It wil not work
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is anonymous block in sql?
What does select * from mean in sql?
How to run sql commands in sql*plus?
What are the benefits of triggers?
What is sql key?
How do I upgrade sql?
How to download oracle sql developer?
Explain 3 basic parts of a trigger.
How to add, remove, modify users using sql?
What are the types of dbms?
what is the difference between truncate and drop statements? : Sql dba
How do I kill a query in postgresql?
What is the difference between python and sql?
What is a string data type in sql?
How many types of triggers are there in pl sql?
