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.

how to enter binary numbers in sql statements? : Sql dba

0 Answers  

---

What is string data type in sql?

0 Answers  

---

how tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers  

---

What are inner and outer joins examples of both?

0 Answers  

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

Which sql statement is used to delete data from a database?

0 Answers  

---

What are the usages of sql?

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

how to create a primary key with out creating an index?

9 Answers   TCS,

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

what is sql profiler

2 Answers   Fidelity,

---