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
- 18621 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / tajuddin
It will work your query 100% will work
Chers
Taj
| Is This Answer Correct ? | 9 Yes | 16 No |
Post New Answer View All Answers
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
what is the difference between join and union? : Sql dba
What is the difference between delete and truncate commands?
Why is pl sql needed?
What is group by in sql?
What is forward declaration in pl sql?
what is the difference between primary key and unique key? : Sql dba
What is the best free sql database?
what is foreign key? : Sql dba
Why do we use function in pl sql?
what are the advantages a stored procedure? : Sql dba
What is difference between sql and mysql?
What do you understand by case manipulation functions?
Why functions are used in sql?
How many columns should be in an index?
