deference between & and &&
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 28 Yes | 1 No |
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;
Is This Answer Correct ? | 7 Yes | 6 No |
which one is currently in used software cmpanies.
how to display last 5 letters from a name (take emp table ename )
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
For web applications from which version of Oracle is suitable?
can u give guidance abt packages of plsql
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
Explain the difference between a data block, an extent and a segment.
where the dff data will be stored
Give the reasoning behind using an index.