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 |
What is chargeback invoice? How do we create it? : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
Can We Restore a Table that accidantly dropped.
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
A scenario for amount correction & how to use amount correction functionality in AP invoices
How would you force a log switch?
how to create an user in oracle 10g.please give me an example..
how can we send a concurrent program output to the clients through mail or fax give me example.
Can we get the deleted Record again if the delete transaction has been committed.
what is correlated subquery
what is the difference b/w oracle8i and oracle9i
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?