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;

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

4 Answers   HP,

---

Could you please let me know the interfaces in OM / FA??

1 Answers   Oracle,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

How would you force a log switch?

1 Answers  

---

Can we modify approve purchase order?if yes what is navigation?

1 Answers   L&T,

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1 Answers  

---

What is the importance of batch source set up in ar? : oracle accounts receivable

1 Answers  

---

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

1 Answers  

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

1 Answers  

---

Where would you look for errors from the database engine?

2 Answers   Fintellix,

---

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.

1 Answers  

---

What is the difference between the SQL*Loader and IMPORT utilities?

1 Answers  

---