It will work your query 100% will work Chers Taj

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 / tajuddin

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

Please Help Members By Posting Answers For Below Questions

what is self-join? : Sql dba

1170

Differentiate between % rowtype and type record.

1312

how to include character strings in sql statements? : Sql dba

1077

What is example of database?

1062

Can you skip header records while loading? : aql loader

1057

What is a temp table?

1032

what is the difference between join and union? : Sql dba

1122

What is difference between left and right outer join?

994

What are properties of the transaction?

998

Is it possible to create the following trigger: before or after update trigger for each row?

1292

Why do we use joins?

1047

What is type and rowtype in pl sql?

1021

What are different types of statements supported by sql?

1166

What is the difference between functions, procedures, and packages in pl/sql?

1057

What is the use of sql trace?

956