Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 22321 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / shailesh j
If column contains data then we can only modify size of
column without changing its data type. But if the column is
empty then we can modify its size as well data type.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does 0 mean in sql?
How does sql*loader handles newline characters in a record? : aql loader
How to place comments in pl/sql?
Is it possible to pass parameters to triggers?
What is difference between sql and oracle?
what are all the different normalizations? : Sql dba
what are the difference between clustered and a non-clustered index? : Sql dba
Does pdo prevent sql injection?
What is example of database?
what are the type of locks ? : Sql dba
how to include comments in sql statements? : Sql dba
Why join is faster than subquery?
Write a query to find the names of users that begin with "um" in sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is the clause we need to add in function body to return variable?
