Answer Posted / esakkiraja

Both of these are substitution variable adn difference
between & and &&:

&--->the variable prefixed with an ampersand (&) to
prompt the user for a value.

eg:
SELECT employee_id, last_name, salary, department_id
FROM employees
WHERE employee_id = &employee_num ;

It should prompt the user to enter a value for employee_num


&&--->Mainly we used the double-ampersand (&&) if you want
to reuse the variable value without prompting the user each
time.

eg:SELECT employee_id, last_name, job_id, &&column_name
FROM employees
ORDER BY &column_name;

Here the user is asked to give the value for variable
column_name only once. The
value supplied by the user (department_id) is used both for
display and ordering of data.

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17779

---

What is the use of lockboxes? : oracle accounts receivable

1262

---

as a technical developer in oracle applications which type errors feced in your experience sofar

2231

---

How would you determine who has added a row to a table?

2382

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2381

---

types of receipts and detail desription about recipts and tables effected by receipts?

2111

---

What is autocashrule set? : oracle accounts receivable

1495

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1190

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1345

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1327

---

Why more redos are generated when the oracle database is in begin backup mode?

1168

---

Explain about party and customer in ar : oracle accounts receivable

1266

---

How would you go about increasing the buffer cache hit ratio?

2650

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2369

---

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1476

---