Re: PL/SQL package to emulate MySQL functions?

On Mon, Nov 19, 2001 at 11:50:20AM -0800, schmoldt_at_fyiowa.com wrote:
> I do know that when I used Migration Workbench to migrate an Access database
> to Oracle, it created Oracle PL/SQL functions to emulate Access builtins
> that Oracle doesn't duplicate - (ANDN, CCUR, CDBL, CINT, DATEADD, EQN, ERIC,
> LEFT, RIGHT, TRIM, etc.)
>
> Maybe the MySql version of Migration Workbench would do the same thing.

The MySql Migration Workbench docs that I've seen didn't mention that so I assumed it didn't (since it's obviously worth mentioning if it does :) I'll download them and investigate some more. Thanks.

Tim.

> Dave
>
> > -----Original Message-----
> > From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> > Sent: Friday, November 16, 2001 12:05 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: PL/SQL package to emulate MySQL functions?
> >
> >
> >
> > Tim,
> >
> > Have you looked at the MySql migration workbench?
> >
> > I don't know if it has what you're looking for, but you never know.
> >
> > http://otn.oracle.com/software/tech/migration/workbench/htdocs
> > /utilsoft.html
> >
> > Jared
> >
> >
> >
> >
> >
> > Tim Bunce
> >
> > <Tim.Bunce_at_pob To: Multiple
> > recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > ox.com> cc:
> >
> > Sent by: Subject: PL/SQL
> > package to emulate MySQL functions?
> > root_at_fatcity.c
> >
> > om
> >
> >
> >
> >
> >
> > 11/16/01 05:35
> >
> > AM
> >
> > Please respond
> >
> > to ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Does anyone know of a PL/SQL package that defines functions to
> > emulate MySQL builtins? That is, MySQL functions like:
> >
> > substring_index(...)
> > unix_timestamp(...)
> > find_in_set(...)
> >
> > If not I guess I may be writing one myself...
> >
> > Tim.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Tim Bunce
> > INET: Tim.Bunce_at_pobox.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Jared.Still_at_radisys.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: schmoldt_at_fyiowa.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Bunce
  INET: Tim.Bunce_at_pobox.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).