RE: Script for reversing a string?

Hi Jay..
 No, you did not miss it.
 It's been an undocmented little nice feature..and I believe it still is undocumented as far as Oracle Docs go.

Cheers !

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Miller, Jay [SMTP:JayMiller_at_TDWaterhouse.com]
> Sent: Wednesday, March 14, 2001 11:11 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Script for reversing a string?
>
> Hi Kirti,
>
> Huh.
>
> This function isn't even mentioned in Koch's Oracle8 The "Complete"
> Reference (I just double checked because I couldn't believe I'd miss
> something like that.
>
> Thanks!
>
> Jay
>
> -----Original Message-----
> Sent: Monday, March 12, 2001 6:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi.
>
> How about using a simple 'reverse' function available with SQL ??
>
> Here is an example from 7.3.4.3 :
>
> Connected to:
> Oracle7 Server Release 7.3.4.3.0 - Production
> With the distributed and parallel query options
> PL/SQL Release 2.3.4.3.0 - Production
>
> SQL> select reverse('oracle') from dual;
>
> REVERS
> ------
> elcaro
>
> And with 8.1.7 :
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
> SQL> select reverse('ORACLE') from dual;
>
> REVERS
> ------
> ELCARO
>
> SQL>
>
> We played with this, probably undocumented feature in 7.3.4, to index
> columns( since reverse key indexes were not available, so this was the
> trick).
>
> HTH..
> - Kirti Deshpande
> Verizon Information Services
> http://www.superpages.com
>
> > -----Original Message-----
> > From: Mandar Ghosalkar [SMTP:MandarG_at_gsr-inc.com]
> > Sent: Monday, March 12, 2001 4:11 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Script for reversing a string?
> >
> > U did the right thing Jay. Oracle does provides u the answer.
> > thats why its called Oracle (answer to everything), except when it comes
> > to
> > licensing
> >
> >
> > select
> > utl_raw.cast_to_varchar2(utl_raw.reverse(utl_raw.cast_to_raw('LOOK')))
> > from
> > dual
> > /
> >
> > -Mandar
> >
> > > -----Original Message-----
> > > From: Miller, Jay [mailto:JayMiller_at_TDWaterhouse.com]
> > > Sent: Monday, March 12, 2001 3:17 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Script for reversing a string?
> > >
> > >
> > > Before I reinvent the wheel, I was wondering if anyone has written a
> > > function that will reverse a string?
> > > Our auditors are requiring that Oracle passwords not contain
> > > the reverse of
> > > the user name and I was about to start writing this function
> > > when I decided
> > > to check here first.
> > >
> > > Thanks!
> > >
> > > Jay Miller
> > >
> > >
> > >
> > > -----Original Message-----
> > > Sent: Friday, March 09, 2001 3:26 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > It hasn't caused me any problems - have only tried it on this
> > > test server so
> > > far, and on my workstation.
> > >
> > > The workstation has Oracle 7.3. and 8.0.4 on it they have
> > > been running for
> > > over a year.
> > >
> > > I wouldn't try this on a production system! These are test
> > > databases only.
> > >
> > > I am just curious why the files are so fragmented.
> > >
> > > Regards,
> > > Patrice Boivin
> > > Systems Analyst (Oracle Certified DBA)
> > >
> > > Systems Admin & Operations | Admin. et Exploit. des systèmes
> > > Technology Services | Services technologiques
> > > Informatics Branch | Direction de l'informatique
> > > Maritimes Region, DFO | Région des Maritimes, MPO
> > >
> > > E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
> > >
> > >
> > > -----Original Message-----
> > > From: Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
> > > Sent: Friday, March 09, 2001 3:36 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Does NT write to random locations on disk?
> > >
> > > I wouldn't think you would want to reorg an Oracle
> > > tablespace with
> > > an NT
> > > defrag utility. You would corrupt the data.
> > > Ron Smith
> > > Database Administration
> > > rlsmith_at_kmg.com
> > >
> > >
> > > -----Original Message-----
> > > Sent: Friday, March 09, 2001 1:01 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Using a little utility called contig I noticed that the
> > > Oracle 8.1.6
> > > datafiles on my test NT server are quite fragmented, an
> > > average of
> > > 177
> > > fragments per file, 118 fragments for the OEM
> > > repository datafile.
> > > The poor
> > > utility couldn't do anything with the database files,
> > > they are too
> > > large
> > > perhaps.
> > >
> > > These were created on an empty server, 8i release 2
> > > went on it after
> > > a
> > > defrag, then the OEM. This is on a hard disk with 1.2G of free
> > > space, none
> > > of the datafiles come close to that.
> > >
> > > Why so many fragments? Oracle created those files in
> > > one pass, does
> > > NT
> > > write randomly to disk or what?
> > >
> > > Won't this have an impact on my NT database's performance?
> > >
> > > Oracle says tablespace fragmentation is not a big deal, but
> > > fragmentation at
> > > the OS level matters. Supposedly that's why NT and
> > > WndowsXX came
> > > with
> > > defragmentation tools.
> > >
> > > ???
> > >
> > > Is there a registry setting somewhere to tell NT to write
> > > contiguously to
> > > disk?
> > >
> > > TIA
> > > Patrice Boivin
> > > Systems Analyst (Oracle Certified DBA)
> > >
> > > Systems Admin & Operations | Admin. et Exploit. des systèmes
> > > Technology Services | Services technologiques
> > > Informatics Branch | Direction de l'informatique
> > > Maritimes Region, DFO | Région des Maritimes, MPO
> > >
> > > E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
> > > <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Boivin, Patrice J
> > > INET: BoivinP_at_mar.dfo-mpo.gc.ca
> > >
> > > 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: Smith, Ron L.
> > > INET: rlsmith_at_kmg.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: Boivin, Patrice J
> > > INET: BoivinP_at_mar.dfo-mpo.gc.ca
> > >
> > > 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: Miller, Jay
> > > INET: JayMiller_at_TDWaterhouse.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: Mandar Ghosalkar
> > INET: MandarG_at_gsr-inc.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: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.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: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.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: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).