OCI Question: Download Questions PDF
Tell me in function why return single value?
Answer:
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.
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.
Download OCI (Oracle Call Interface) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is the main difference between foreign key and primary key? | Can we use a having clause in groupby clause? |