Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 28 Yes | 1 No |
Post New Answer View All Answers
Why more redos are generated when the oracle database is in begin backup mode?
What is mrc and what is its use? : oracle accounts receivable
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is the importance of batch source set up in ar? : oracle accounts receivable
Where in the Oracle directory tree structure are audit traces placed?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
how to replace not in with not exist?
What is the disk migration? what is the steps involved in oracle disk migration?
How would you go about increasing the buffer cache hit ratio?
what is semphore explian it?
key flexfield structure
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
difference of using cursor for loop and open,fetch,close.which one is better
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
