Give syntax for SQL and ORACLE joins.

0 Answers   TCS,

---

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

---

Will you be able to store pictures in the database?explain.

0 Answers  

---

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?

1 Answers  

---

How do we represent comments in oracle?

0 Answers  

---

What is meant by a deadlock situation?

0 Answers  

---

what are the disadvantages of hierarchial database over RDBMS?

1 Answers   TCS,

---

what is primary key?

9 Answers  

---

What do you mean by a tablespace?

0 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

What are various constraints used in SQL?

1 Answers   Polaris,

---

what are steps for interface? where is exchange rate defined in which table?

0 Answers  

---