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
- 18469 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 join and explain different type of joins? : Sql dba
What does 0 mean in sql?
What is the difference between truncate and drop statements?
Which is faster truncate or drop?
How do I save a sql query?
What is the difference between function and procedure in pl/sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
How to rename a column in the output of sql query?
Does mysql_real_escape_string prevent sql injection?
How does sql*loader handles newline characters in a record? : aql loader
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What does plv msg allows you to do?
What is an intersect?
What is primary key sql?
What are the ddl commands?
