ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle AllOther
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
deference between & and &&
 Question Submitted By :: Amar_kondla
I also faced this Question!!     Rank Answer Posted By  
 
  Re: deference between & and &&
Answer
# 1
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 ?    0 Yes 0 No
Esakkiraja
 

 
 
 
Other Oracle AllOther Interview Questions
 
  Question Asked @ Answers
 
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun  1
What are the main diff. between oracle 7.3 and oracle 8i?  1
What is the difference between the SQL*Loader and IMPORT utilities?  1
What does coalescing a tablespace do?  1
Compare and contrast TRUNCATE and DELETE for a table.  2
pl help me, i want oracle HRMS training institute address,in chennai  1
what are important reports in HRMS,GL,AP,AR in oracle apps? Pathway-Technologies1
Name a tablespace automatically created when you create a database.  1
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value IBM4
When the procedures or packagess become invalidate TCS2
How can you rebuild an index?  1
Can We Restore a Table that accidantly dropped. TCS2
How do you use trigger to create mutating state of table TCS2
How can you gather statistics on a table?  2
WHAT IS CARTESIAN PRODUCT?  2
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?  3
how to display last 5 letters from a name (take emp table ename ) IBM2
Explain the difference between a data block, an extent and a segment. IBM1
what is the difference between TRUNCATE and DELETE command in SQL TCS12
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?  1
 
For more Oracle AllOther Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com