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
- 22335 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 pl sql architecture?
What is over () in sql?
What does bitemporal mean?
What is query syntax?
How can you save or place your msg in a table?
How do I add a database to sql?
How do you truncate?
What is the difference between Union and Union all. Which is faster.
What are types of exception?
What does pragma mean?
How much does sql certification cost?
How long will it take to learn pl sql?
Why do we need sharding?
What is a subquery in sql?
Is sql a backend?
