How To Return A Select Result In A Function?
(Doc ID 1399434.1)
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version: 10.2.0.3
Information in this document applies to any platform.
How to specify the functions return value?
Those select statements could be interpreted as a parametrized function. This would shorten the over all statement length very much.
(select * from anytable where aParameter2 ... )
return select * from anytable where aWithAParam ...;
select * from( DoSubSelect(aParameter1) union DoSubSelect(aParameter2)) where ...
Is this possible with Oracle SQL syntax?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|