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

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1244


What is Tax Categories?

1632


What is the importance of batch source set up in ar? : oracle accounts receivable

717


Difference between transaction type and transaction sources. : oracle accounts receivable

578


A scenario for amount correction & how to use amount correction functionality in AP invoices

1653






What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3337


What is the disk migration? what is the steps involved in oracle disk migration?

722


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

1834


How to clone the database using RMAN back

1617


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

671


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1497


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

1623


TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

2838


Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

666


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

2057