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.

13 Answers   Oracle, TCS,

---

What is sqlerrd?

0 Answers  

---

How do you delete data from a table?

0 Answers  

---

What is function and procedure in pl sql?

0 Answers  

---

How do you copy a table in sql?

0 Answers  

---

How do I save the results of sql query in a file?

0 Answers  

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

What is diff between bulk collect and forall

3 Answers   Metric Stream,

---

What is the difference between join and natural join?

0 Answers  

---

What are different categories of sql commands?

0 Answers  

---

What are pl/sql cursors?

0 Answers  

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---