Tell me in function why return single value?
Submitted by: AdministratorFUNCTION 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online OCI Job Interview Questions And Answers
Top OCI Questions
| ☺ | What is database normalization? |
| ☺ | What is the main difference between foreign key and primary key? |
| ☺ | Tell me in function why return single value? |
| ☺ | What is difference between SQL Server and Oracle? |
| ☺ | Can we use a having clause in groupby clause? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
