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
- 18467 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / sathish p
We cant change column datatype while the column having
values.. Bcos error will come when u run the Alter table
modify statement...
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
what is the difference between a having clause and a where clause? : Sql dba
What does the acronym acid stand for in database management?
Why indexing is needed?
Can we use two order by clause in query?
What is trigger and types?
What are the types of join in sql?
Are pl sql variables case sensitive?
What are the different dcl commands in sql?
Is it important to partition hard disk?
Can we write dml inside a function in sql server?
How do I delete a trigger?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How does an execution block start and end in pl sql?
What are the ddl commands?
