Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Script for reversing a string?

RE: Script for reversing a string?

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Mon, 12 Mar 2001 16:12:29 -0800
Message-ID: <F001.002CA4E0.20010312154027@fatcity.com> 






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).


Received on Mon Mar 12 2001 - 18:12:29 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US