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
- 20336 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / tajuddin
It will work your query 100% will work
Chers
Taj
| Is This Answer Correct ? | 9 Yes | 16 No |
Post New Answer View All Answers
What is indexes?
How delete all data from all tables in sql?
Which data type is a composite type?
How can check sql version from command line?
Can a commit statement be executed as part of a trigger?
Write the alter statement to enable all the triggers on the t.students table.
What is an emotional trigger?
What is the purpose of cursors in pl/sql?
When are we going to use truncate and delete?
How to check if a column is nullable before setting to nullable?
How do you declare a user-defined exception?
what happens if you no create privilege in a database? : Sql dba
what is myisam? : Sql dba
- 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?
Explain raise_application_error.
