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
21996 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 the most important ddl statements in sql are?

947

what is unique key constraint? : Sql dba

993

Enlist some predefined exceptions?

999

What are the types of join and explain each?

989

How to fix oracle error ora-00942: table or view does not exist

958

Explain the update statement in sql

918

how to use case expression? : Sql dba

960

What is Collation Sensitivity ? What are the various type ?

906

what is auto increment? : Sql dba

966

What are pl/sql packages?

1037

Is not null in sql?

932

What is pl sql block structure?

975

which tcp/ip port does sql server run on? : Sql dba

966

What is use of term?

1009

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

903