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
- 18508 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
It wil not work
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is rownum in sql?
what is the difference between group by and order by in sql? : Sql dba
How do I remove sql developer from windows 10?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Can you load data into multiple tables at once? : aql loader
What is the difference between view and stored procedure?
What are sql ddl commands?
What is embedded sql in db2?
Which sql statement is used to return only different values?
Is sqlexception checked or unchecked?
What is mutating error?
What is trigger types of trigger?
What are tables in sql?
Can I join the same table twice?
What is the difference between left and left outer join?
