Re: PL/SQL based price conversion, is it possible?

From: Nicolas MONNET <nico_at_monnet.to>
Date: Fri, 15 Sep 2000 16:50:47 +0100
Message-ID: <qNqw5.256$86.7236@tengri.easynet.fr>

In article <8ptb83$qg2$1_at_nnrp1.deja.com>, Mark D Powell <markp7832_at_my-deja.com> wrote:

> Sounds like a job for a function. Write a function to perform the
> conversion for the referenced column and then provide a view that
> applies the function to the price column and renames it back to price.
> Now when selected you get the converted price auto-magically.

Yep, but is there anyway to enter a parameter in this? Can I, for example do something like:

SELECT price FROM inventory('USD') WHERE stuff = 'good';

Any idea? Received on Fri Sep 15 2000 - 10:50:47 CDT