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.

can u give guidance abt packages of plsql

2174

---

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1173

---

What is the difference between oracle media recovery and crash recovery?

1176

---

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

17641

---

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

1393

---

how to replace not in with not exist?

3739

---

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2522

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1090

---

What is the sql query to find the employee who has Nth maximum salary?

5331

---

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3582

---

How many segment are present in Oracle Manufacturing

2320

---

What is db_recovery_file_dest in oracle? When do you need to set this value?

1125

---

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?

2411

---

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

1776

---

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

2465

---