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
- 21973 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
What problem one might face while writing log information to a data-base table in pl/sql?
What are the different types of dbms?
Mention what does plv msg allows you to do?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
How can I make sql query run faster?
How to avoid using cursors?
What is a table in a database?
how to include numeric values in sql statements? : Sql dba
Why partition by is used in sql?
how to select first 5 records from a table? : Sql dba
What's the difference between inner join and left join?
difference between anonymous blocks and sub-programs.
What is difference between joins and union?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
how can you create an empty table from an existing table? : Sql dba
