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
- 18511 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / ramesh
It will work 100%.
becos. we are increasing the length. if we are decreasing
the length then it gives error.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
how tsql statements can be written and submitted to the database engine? : Transact sql
Why is partition used in sql?
How do we accept inputs from user during runtime?
How do you drop a trigger?
What is cost in sql execution plan?
Explain what is sql*plus?
Why partition by is used in sql?
What is sql integrity?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is the usage of nvl function?
What are local and global Indexes and where they are useful.
What is the use of non clustered index?
what is a view? : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba
How to call shell script from pl sql procedure?
