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
- 22840 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 is break?
Is ms sql is free?
What is a natural join?
Does truncate need commit?
How to read xml file in oracle pl sql?
Why functions are used in sql?
What is normalisation and its types?
What is null in pl/sql?
Why is nosql good?
how to present a past time in hours, minutes and seconds? : Sql dba
Why we use cross join?
What does rownum mean in sql?
How many types of triggers are there in pl sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Is sql dba a good career? : SQL DBA
