Answer / 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.

Answer / fahad

&-it is used in run time.it ask d value as new and old value
&&-it repeats the duplicacy and it repeat d same output..
ex.single ampersent...
select employee_id,last_name,hire_date,salary from employees
where department_id=&department_id;
when u enter dis statement.
in output it vil ask d value..
enter value for department_id=



query for &&..
select employee_id,last_name,hire_date,salary from employees
where department_id=&&department_id;

What is chargeback invoice? How do we create it? : oracle accounts receivable

0 Answers  

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

0 Answers  

---

Can We Restore a Table that accidantly dropped.

8 Answers   TCS,

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers  

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  

---

---

How would you force a log switch?

1 Answers  

---

how to create an user in oracle 10g.please give me an example..

1 Answers  

---

how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers   Cap Gemini,

---

Can we get the deleted Record again if the delete transaction has been committed.

4 Answers  

---

what is correlated subquery

3 Answers  

---

what is the difference b/w oracle8i and oracle9i

3 Answers   iGate,

---

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 Answers  

---