How do you update a sql procedure?

0 Answers  

---

Explain scalar functions in sql?

0 Answers  

---

What is procedure function?

0 Answers  

---

write the Sql query for creating database backup?

7 Answers   TCS,

---

What is different between union and minus?

7 Answers   Accenture, TCS,

---

---

What is sql*loader and what is it used for?

0 Answers  

---

What is the difference between pl and sql?

0 Answers  

---

What is a crud api?

0 Answers  

---

What is sqlca in powerbuilder?

0 Answers  

---

Advantages and disadvantages of stored procedure?

0 Answers  

---

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

---

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,

---