1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 Answers  

---

How to drop a stored procedure in oracle?

0 Answers  

---

what is data abstraction

3 Answers   Semantic Space,

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

How can we create the complete backup of data in the oracle.

0 Answers   IPEC, Satyam, SunTec,

---

Can you use a commit statement within a database trigger?

4 Answers  

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

0 Answers  

---

what are archived logs?

0 Answers  

---

What is a Sequence ?

3 Answers  

---

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers  

---

Can a primary key contain more than one columns?

2 Answers  

---

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers   Verizon,

---