It will not work, If u have data in a table and u have to change data ty

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.

Question Posted / nilesh

13 Answers
22490 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

Please Help Members By Posting Answers For Below Questions

What are database links used for?

1048

How do I install sql?

1002

What operating systems are supported by oracle sql developer?

966

What are the operators used in select statements?

1058

How many types of normalization are there?

966

Can we use rowid as primary key?

989

what are the different type of normalization? : Sql dba

1027

Explain the purpose of %type and %rowtype data types?

928

How many commands are in sql?

1073

How do you run a query?

990

How to change the order of columns in Oracle SQL Plus ?

1058

Can %notfound return null after a fetch?

1060

what is a trigger in mysql? Define different types of trigger. : Sql dba

1069

What do you know by pl/sql cursors?

1105

What are the advantages of pl sql over sql?

1025