OCI Question:
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.
Previous Question | Next Question |
What is the main difference between foreign key and primary key? | Can we use a having clause in groupby clause? |