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
- 20309 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / subbarayulu
It Will not work properly. when ever the table with data
user can't chage the column's datatype. It allows to
increase the size of the data type only.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
Write a query to display the current date in sql?
what is offset-fetch filter in tsql? : Transact sql
What is the left table in sql?
Can we use two order by clause in query?
How do you delete duplicates in sql query using rowid?
What is replication id?
What is #table in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
what is a composite key ? : Sql dba
how to decrement dates by 1 in mysql? : Sql dba
What are the sql versions?
When is the update_statistics command used?
How do I create an index in word?
How are functions and procedures called in PL/SQL?
What is the difference between view and stored procedure?
