What is cursor

4 Answers   TCS,

---

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,

---

What are the predefined tablespaces in a database?

0 Answers  

---

Write a trigger example in oracle?

0 Answers  

---

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

Difference between an implicit & an explicit cursor.?

2 Answers  

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

What does sharding mean?

0 Answers  

---

what is the syntax of SELECT command?

6 Answers  

---

Whatz the main diff between Subquery and a Join

14 Answers   Oracle, Zeta Interactive,

---

How to declare a local variable?

0 Answers  

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers   eicc,

---