What has stored procedures in sql and how we can use it?

0 Answers  

---

Can we insert data into materialized view?

0 Answers  

---

What are triggers and its types?

0 Answers  

---

Can unique keys be null?

0 Answers  

---

What is the advantage of index in sql?

0 Answers  

---

---

What is differance unique key and primary key.

7 Answers   EDS,

---

What is int identity in sql?

0 Answers  

---

State the difference between implict and explict cursor's?

7 Answers   CTS,

---

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

---

What is ttitle and btitle?

0 Answers  

---

What problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---