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
- 22541 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / nilesh
It will not work,
If u have data in a table and u have to change data type
number to varchar2 then it will gives error, If u change
varchar2(100) column to char(200) it will work,
The number to varchar2 or varchar2 to number will not work
when u have data in table.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is input buffer in sql*plus?
What is field delimiter?
Is sql a dbms?
What is %s in sql?
How many databases can sql express handle?
What are sql indexes?
How can we make an if statement within a select statement?
Write a query to find the names of users that begin with "um" in sql?
What is full form of rtm?
how to escape special characters in sql statements? : Sql dba
where are cookies actually stored on the hard disk? : Sql dba
What packages are available to pl/sql developers?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Can you join a table to itself?
Why self join is used in sql?
