Re: clustering and high availability?

From: Kalmact <kalmact_at_hotmail.com>
Date: 16 Jun 2004 02:21:08 -0700
Message-ID: <8007e332.0406160121.1e03309c@posting.google.com>

thomas.kyte_at_oracle.com (Thomas Kyte) wrote in message news:<7b0834a8.0406140709.5af3025d_at_posting.google.com>...
> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<40cd533a$0$11521$afc38c87_at_news.optusnet.com.au>...
> > "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> > news:1087195407.21563_at_yasure...
> About that water into wine thing -- I'm still working on that. It
> could save me huge amounts of money.

Hi Tom,

   Are you trying to do it in PL/SQL :-) I am sure it would be more popular then your script to find out sqls not using bind variables. Anyway, I thought about it and this is what I came up with

SQL>create or replace function water_to_wine (p_water in varchar2) return varchar2 is

  2     -- This function turns water into wine.
  3     -- A similar function is being written to turn any liquid into
wine
  4     invalid_data exception;
  5  begin
  6     if upper(p_water) = 'WATER' then
  7        return 'WINE';
  8     else
  9        raise invalid_data;
 10     end if;

 11 end;
 12 /

Function created.

SQL>select water_to_wine('water') from dual;

WATER_TO_WINE('WATER')

---

WINE Regards,
Kal Received on Wed Jun 16 2004 - 04:21:08 CDT