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 many tables will create when we create table, what are they? : Sql dba

0 Answers  

---

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

0 Answers  

---

What are sql constraints?

0 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

---

is mysql query is case sensitive? : Sql dba

0 Answers  

---

Why we use cross join?

0 Answers  

---

How to set up sql*plus output format in oracle?

0 Answers  

---

How to get unique records from a table?

0 Answers  

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---

What does cursor do in sql?

0 Answers  

---

What is a recursive stored procedure?

0 Answers  

---