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.

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

What is an Integrity Constraint?

4 Answers  

---

Is sql a backend language?

0 Answers  

---

What is input buffer in sql*plus?

0 Answers  

---

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

---

What does an inner join do?

0 Answers  

---

What is an escape character in sql?

0 Answers  

---

What is difference between pls_integer and integer?

0 Answers  

---

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

---

Define union, minus, union all, intersect ?

0 Answers  

---

How do I start sql from command line?

0 Answers  

---

How do you modify a column in sql?

0 Answers  

---