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.

How do you create a credit note against an invoice? : oracle accounts receivable

1070

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

2699

---

what are basic modules required to implement oracle application in any oraganisation?

2186

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2047

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2397

---

What Are Cross Validation & Adi?

1141

---

What is the difference between recovery and restoring of the oracle database?

1193

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

1195

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1758

---

Difference between transaction type and transaction sources. : oracle accounts receivable

1012

---

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1244

---

what is difference between inner join & nested query or subqueries

3011

---

What view would you use to determine free space in a tablespace?

2209

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2451

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2086

---