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;

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

0 Answers   Wipro,

---

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

0 Answers  

---

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

0 Answers  

---

what is different between inline query,subquery& corelated query?

8 Answers   Quest,

---

default triggers available for reports

0 Answers  

---

What view would you use to look at the size of a data file?

1 Answers  

---

What are the mandatory setups in setting up a PO in oracle

1 Answers   Silicon,

---

Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,

---

how to display last 5 letters from a name (take emp table ename )

6 Answers   IBM,

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

0 Answers  

---

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

4 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  

---