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 can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1 Answers  

---

What is sql query limit?

1 Answers  

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1 Answers  

---

How do I add a primary key to a table?

1 Answers  

---

How can you create Cursor with parametres ?

3 Answers  

---

How to access the current value and next value from a sequence?

6 Answers  

---

explain mysql aggregate functions. : Sql dba

1 Answers  

---

Explain the uses of control file.

1 Answers  

---

Explain dml and ddl?

1 Answers  

---

What is sql and its types?

1 Answers  

---

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

---

give the syntax of grant and revoke commands? : Sql dba

1 Answers  

---