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
- 18479 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
what is a database? : Sql dba
Can we join two tables without common column?
What is sorting in sql?
How does postgresql compare to mysql?
Can a foreign key be null?
What is the purpose of cursors in pl/sql?
What are the set operators in sql?
What does where 1 1 mean in sql?
Which is better cte or subquery?
How to move files from one directory to another in pl sql?
How many postgresql users are there, worldwide?
What is dba in sql? : SQL DBA
Can you call pl/sql package functions from within a fast formula?
What is sql key?
what are all types of user defined functions? : Sql dba
