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
- 18554 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
Explain alias in sql?
Why we use stored procedure instead of query?
How to place comments in pl/sql?
How do I upgrade sql?
How do I send sql query results to excel?
Is primary key is clustered index?
Explain cursor types?
Why do we need pl sql?
What is case function?
what is a trigger? : Sql dba
Why is the cursor important?
what is an alias command? : Sql dba
How is a PL/SQL code compiled?
What are different types of sql?
What is the requirement of self-join?
