From JayMiller@TDWaterhouse.com Wed, 14 Mar 2001 13:09:27 -0800 From: "Miller, Jay" Date: Wed, 14 Mar 2001 13:09:27 -0800 Subject: RE: Script for reversing a string? Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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@mar.dfo-mpo.gc.ca > > > > > > -----Original Message----- > > From: Smith, Ron L. [SMTP:rlsmith@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@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@mar.dfo-mpo.gc.ca > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Boivin, Patrice J > > INET: BoivinP@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@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@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@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@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@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@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@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@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@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@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@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@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@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).