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
- 18478 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / subbarayulu
It Will not work properly. when ever the table with data
user can't chage the column's datatype. It allows to
increase the size of the data type only.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is an intersect?
What is parameter substitution in sql?
Explain the difference between triggers and constraints?
What are stored procedures used for?
What is data type in sql?
How do I sort a table in sql?
Is json a nosql?
Why we use cross join?
What is update query?
What are the types of views in sql?
What is the difference between function and procedure in pl/sql?
What is minus?
explain advantages of innodb over myisam. : Sql dba
How do I quit sql?
