what are the advantages a stored procedure? : Sql dba

0 Answers  

---

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

---

What is the difference between microsoft sql and mysql?

0 Answers  

---

What is sqlite format?

0 Answers  

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,

---

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

Does view contain data?

0 Answers  

---

Its possible to add more than one primary key for the table

4 Answers  

---

What are the types of dbms?

0 Answers  

---

How do I run sql profiler?

0 Answers  

---

What is trigger price?

0 Answers  

---

What are pl/sql cursors?

0 Answers  

---