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
- 20307 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / reddi
It won't work coz number can't datatype can't be changed to
varchar. If data does not exits then its work fine.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is difference between pls_integer and integer?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is the difference between functions, procedures, and packages in pl/sql?
What is the difference between pl and sql?
What does plv msg allows you to do?
what are local and global variables and their differences? : Sql dba
How to write pl sql program in mysql command prompt?
Can sql developer connect to db2?
What is keys and its types?
What is difference between joins and union?
What are the various restrictions imposed on view in terms of dml?
How do you take the union of two tables in sql?
What are the commands used in sql?
What is nosql vs sql?
What is the use of primary key?
