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
- 22845 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 are the types of views in sql?
What is posting?
How do I sort a table in sql?
What types of commands can be executed in sql*plus?
What is the difference between nvl function, ifnull function, and isnull function?
What is the difference between microsoft access and sql server?
Is not equal in sql?
What is a string data type in sql?
Explain the select statement in sql?
What is a full join?
Can we use pl sql in mysql?
what is datawarehouse? : Sql dba
What is synonyms?
Which table is left in left join?
How do you remove duplicates without using distinct in sql?
