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
- 22494 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 t sql in sql server?
how to use case expression? : Sql dba
What is record data type?
What is the execution plan in sql?
Why is stored procedure faster than query?
What is record in pl sql?
how would you enter characters as hex numbers? : Sql dba
Is pl sql different from sql?
What is difference between procedure and trigger?
What is the difference between inner join and left join?
Is sql an operating system?
Write a query to display the current date in sql?
Can we insert in sql function?
Is a view faster than a stored procedure?
how can we know the number of days between two given dates using mysql? : Sql dba
