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
- 22849 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / lakshmanakumar
There should be error raised as below
ORA-01439: column to be modified must be empty to change
datatype
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are all types of user defined functions?
Why do we use procedures in pl sql?
What is the use of sql trace?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Is sql a oracle?
Can primary key be changed?
What is the difference between null value, zero, and blank space?
Why trigger is used in sql?
What are the methods of filing?
How can we make an if statement within a select statement?
What is sql server and ase?
How do you declare a constant?
What is the difference between the conventional and direct path loads? : aql loader
Which is faster count (*) or count 1?
Why is sharding used?
