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;

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

0 Answers  

---

Olap tools

0 Answers  

---

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?

0 Answers   Cap Gemini,

---

Explain prerequisites and post activities of oracle database installation

0 Answers  

---

why r u using etl tool.

2 Answers  

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,

---

What is the use of lockboxes? : oracle accounts receivable

0 Answers  

---

what is sql*loader parameters and where we will use it.

1 Answers   Accenture,

---

What is the difference between conversions and interfaces? : oracle accounts receivable

0 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

what are the API of GL,PO,AP

0 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  

---