Answer / kumar

Every online transaction is having credit debit
transactions. Suppose if client is transferred money from
his account to another account. The client account will be
debited and other party account will be credited.
If we are maintaining only client account from our end.
These transactions details will be updated/inserted into
database tables. This can be achieved by writing pl/sq l
program unit
can be called from other interfaces.

I think this is a normal process for testing what we do for
pl/program units.

When client performs online transaction back end pl/sql
program unit will be called and the corresponding data base
will be effected.

what are all types of user defined functions? : Sql dba

0 Answers  

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

What does (+) mean in sql joins?

0 Answers  

---

Explain constraints in sql?

0 Answers  

---

What will you get by the cursor attribute sql%found?

0 Answers  

---

Why does sql need a server?

0 Answers  

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---

What is error ora-01000: maximum open cursors exceeded

0 Answers  

---

What does partition by mean in sql?

0 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

how to create a test table in your mysql server? : Sql dba

0 Answers  

---

What is %s in sql?

0 Answers  

---