What are synonyms in sql?

0 Answers  

---

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

---

Can we use pl sql in sql server?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

how do you tune the slow running queries in oracle db , explain the methodology

0 Answers  

---

what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,

---

What are the dml statements?

0 Answers  

---

What is varchar used for?

0 Answers  

---

What are local and global variables and their differences?

0 Answers  

---

How do you write a subquery?

0 Answers  

---

What is the basic structure of PL/SQL ?

6 Answers  

---