What are three advantages to using sql?

0 Answers  

---

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,

---

How do you determine the current isolation level? : Transact sql

0 Answers  

---

Cite the differences between execution of triggers and stored procedures?

0 Answers  

---

What is the largest value that can be stored in a byte data field?

0 Answers  

---

What is rank function in sql?

0 Answers  

---

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

What are primary key and foreign key and how they work?

0 Answers  

---

What is Referential Integrity?

3 Answers   IBM,

---

How can I make sql query run faster?

0 Answers  

---

Can you have a foreign key without a primary key?

0 Answers  

---