What is a trigger and what are its types?

0 Answers  

---

What are main difference between Stored Procedure and Functions.

6 Answers   CA, Metric Stream,

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

0 Answers   Wipro,

---

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

---

How do I know if oracle client is installed on windows?

0 Answers  

---

what is primary key and foreign key when and where have to use

5 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

What is the sid in oracle?

0 Answers  

---

What is meant by joins? List out the types of joins.

0 Answers  

---

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

0 Answers   ESS,

---

what is the difference between dbms and rdbms?

3 Answers   Oracle,

---