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.

Download OCI (Oracle Call Interface) Interview Questions And Answers PDF

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