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
- 18480 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / shailesh j
If column contains data then we can only modify size of
column without changing its data type. But if the column is
empty then we can modify its size as well data type.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are few of the schema objects that are created using PL/SQL?
what is csv? : Sql dba
What are triggers and its types?
How do you modify a trigger?
How are functions and procedures called in PL/SQL?
What are the types pl/sql code blocks?
What are the ways on commenting in a pl/sql code?
What is trigger and stored procedure in sql?
Does sql support programming?
What is an inner join sql?
which tcp/ip port does sql server run on? : Sql dba
How do I remove sql plus from windows 10?
How do I run a sql query?
what is an alias command? : Sql dba
How do I view stored procedures?
