Re: calculating values to be used later in Oracle SQL

for me it's crucial to understand your "later on". As long as you mean "within the current session" I'd create a package and store the values there.

For (result)sets I'd take Global Temporary Tables.

hth
 Martin

On Fri, Feb 21, 2014 at 6:10 PM, William Threlfall < William.Threlfall_at_albertahealthservices.ca> wrote:

> *I **think** there **ought to** be a way to calculate variables and use
> them later on**, but I**'**m just not clueing in at the moment.*
>

--
http://www.freelists.org/webpage/oracle-l