Re: Help! SQL*Plus Questions!

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1998/03/25
Message-ID: <6f9rfv$otu@bgtnsc02.worldnet.att.net>#1/1

On Mon, 23 Mar 1998 18:53:26 GMT, Richard Fairbairn <r.fairbairn_at_zetnet.co.uk> wrote:

>Hi there. I have SQL*Plus running on Windows 95. I wonder whether
>anyone can take a moment to answer the following questions:
>

Just for the record, SQL*Plus an SQL are different things.

>Is there a function in SQL which will convert a number to years and
>months (E.g.,, the result of a months_between(thisdate, thatdate))?
>I'm pretty sure that a little algorithm must be written to take care
>of this, but if you know different please let me know!

I'm not aware of anything, but you should be able to use the MOD to get at what you want.

>
>Also, does anyone know how the current cost of Personal Oracle 7 for
>Windows 95 and the Developer 200 suite of applications? If you have
>the answer in UK pounds I'd be delighted!

In US$, the cost of Personal Oracle is $395. I'm not certain of the price for Dev 2000. Received on Wed Mar 25 1998 - 00:00:00 CST