OCI Question:

Tell me in function why return single value?

OCI (Oracle Call Interface) Interview Question
OCI (Oracle Call Interface) Interview Question

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.


Previous QuestionNext Question
What is the main difference between foreign key and primary key?Can we use a having clause in groupby clause?