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
22941 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

Why self join is used in sql?

1035

Can we use ddl statements in stored procedure sql server?

1068

What is partition in sql query?

1051

What are the different types of a subquery?

1121

what are the different index configurations a table can have? : Sql dba

1056

Write a sql query to get the third highest salary of an employee from employee_table?

1127

describe transaction-safe table types in mysql : sql dba

1073

What is cartesian join in sql?

1206

What is range partitioning?

1022

Explain the the update statement in sql?

1108

What is cursor in pl sql with examples?

1102

how to load data files into tables with 'mysqlimport'? : Sql dba

1155

What is the difference between row level and statement level trigger?

1075

Explain aggregate functions are available there in sql?

1053

What are triggers and its types?

1127