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
- 18510 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 vector point function?
what are the t string functions available in tsql? : Transact sql
How to Declare Fixed Length String Value In PL SQL
How to handle bulk data?
How to check if a column is nullable before setting to nullable?
Which command is used to delete a package?
How do we accept inputs from user during runtime?
what is the use of friend function? : Sql dba
Is microsoft sql free?
what are the security recommendations while using mysql? : Sql dba
What is range partitioning?
Why is the cursor important?
How can you tell the difference between an index and a view?
Can you join a table to itself?
How do I view tables in mysql?
