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 |
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Give the two types of tables involved in producing a star schema and the type of data they hold.
How would you go about generating an EXPLAIN plan?
How client makes connection with server in client/server architecture?
what is the difference b/w oracle8i and oracle9i
Explain the use of table functions.
HOW TO SPOT AHIERARCHY?
can we drop dual table
Explain an ORA-01555
Explain the difference between a hot backup and a cold backup and the benefits associated with each
What is the use of lockboxes? : oracle accounts receivable
What is an Oracle database Partial Backup?