ALLInterview.com :: Home Page            
 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  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
   
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  OCI
 
 


 

 
 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
in fun why return single value?
 Question Submitted By :: Sujata
I also faced this Question!!     Rank Answer Posted By  
 
  Re: in fun why return single value?
Answer
# 1
FUNCTION HAVING SINGLE RETURN PARAMEATER.IT IS USED FOR
CALICULATION PURPOSE.

EX: CRETE OR REPLACE FUNCTION [PARAMEATER] RETURN TYPE;
BEGIN
RETURN PARAMEATER;
END;

BUT FUNCTIONS RETURN MORE THAN ONE VALUES ALSO,BY USING
RECORD TYPES.
 
Is This Answer Correct ?    0 Yes 0 No
Chiranjeevi
 

 
 
 
Other OCI Interview Questions
 
  Question Asked @ Answers
 
what is difference between sqlserver and oracle? CMC5
what is thae main difference between foreingkey and primarykey  5
what is normalization NIC2
can we use a having cluase in groupby clause. if there are 500 records i will give rownumber<250 then how many records does it retrieve. wt is the result of nvl2(null,notnull,null) if there are four tables without using cartesian how many joins can be there. in the sql subqueries wt is the parent ans1)select 2)update,3) delete 4)2&3 i22
REGULAR CLASSES for Informatica 8.6 is starting from Monday, 07th Nov, 8:00 AM IST .  1
what is difference between sap and oracle applications and which is now market leader? Unilogic-Software11
I have table that has student names in it.If I query on the names my result set should return as 'VALUE NOT ENTERED' for null entries.  1
what are collection attributes GE1
in fun why return single value? UST1
 
For more OCI Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

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