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
22478 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 difference between sql and mysql?

1131

What is the difference between clustered and non-clustered index in sql?

1015

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1041

Explain what is a subquery ?

1186

What is clause in sql?

1108

What is a temporal data type?

1052

Show code of a cursor for loop.

1054

What are the constraints available in sql?

1046

Is pl sql still used?

975

Is sqlite thread safe?

1046

What is the use of triggers?

1037

What is clustered index in sql?

1051

what are null values? : Sql dba

951

Is progress software supports to ( pl/sql )?

1037

How can I make sql query run faster?

1015