19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

where we have to use ON clause and where we have to use USING clause in JOINS

2 Answers  

---

What is tns entry?

0 Answers  

---

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

Can we store pictures in the database and if so, how it can be done?

0 Answers  

---

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 Answers  

---

According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

2 Answers  

---

Explain about your project and its relation to the current job position you are applying to?

0 Answers  

---

What is an index associated with a constraint?

0 Answers  

---

What is the dynamic sql in oracle?

0 Answers  

---

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,

---

How to create a stored program unit?

0 Answers  

---