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 the syntax and use of the coalesce function?

0 Answers  

---

diff b/w function and procedure?

9 Answers   iFlex,

---

Which command is used to delete a package?

0 Answers  

---

Is nosql faster than sql?

0 Answers  

---

---

What is data modelling in sql?

0 Answers  

---

Do stored procedures prevent sql injection?

0 Answers  

---

What is a sql statement?

0 Answers  

---

What is a recursive stored procedure?

0 Answers  

---

What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,

---

How to load data with sql*loader?

0 Answers  

---

Which software is used for pl sql programming?

0 Answers  

---