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
- 22939 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
How many types of literals are available in pl sql?
How do you explain an index number?
What is a unique key and primary key and foreign key?
Why do we use %rowtype & %type in plsql?
What is trigger in flip flop?
Is sql port 1433 encrypted?
What is the use of desc in sql?
What is the difference between sql, mysql and sql server?
How do you truncate?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What does select top 1 do in sql?
what are all the different normalizations? : Sql dba
Can we use insert statement in function?
What is the usage of when clause in trigger?
what is the different between now() and current_date()? : Sql dba
