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

Can we create view in stored procedure?

1028

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7508

What is the purpose of using pl/sql?

1192

Which join is like inner join?

1093

What is a sql trace file?

1092

describe mysql connection using mysql binary. : Sql dba

1127

How does left join work in sql?

1059

What is union, minus and interact commands?

1374

Is sql difficult?

1236

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1099

What are % type and % rowtype?

1085

What is a procedure in pl sql?

1297

Why commit is not used in triggers?

1094

What is a primary key sql?

1097

How do I debug a stored procedure?

1171