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
- 20298 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / rinson
It will raise error ora-1439 column to be modifiedy must be
empty to change datatype.
| Is This Answer Correct ? | 26 Yes | 2 No |
Post New Answer View All Answers
What is oracle and pl sql?
Define join and name different types of joins?
what is data manipulation language? : Sql dba
can sql servers linked to other servers like oracle? : Sql dba
What are the two types of exceptions.
what is union, minus and interact commands? : Sql dba
What are the popular database management systems in the it industry?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Can dml statements be used in pl/sql?
what is rdbms? : Sql dba
What is a unique constraint?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What are the different dml commands in sql?
What pl/sql package consists of?
What is the difference between count 1 and count (*) in a sql query?
