deference between & and &&

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which one is currently in used software cmpanies.

1651


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1981


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2049


types of receipts and detail desription about recipts and tables effected by receipts?

1623


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1614






1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1640


default triggers available for reports

1755


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1827


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

640


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1486


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

1902


how to replace not in with not exist?

3183


now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

1791


Why more redos are generated when the oracle database is in begin backup mode?

655


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

1762