True, though the exact example I was thinking of was when someone was access a database they only had select access to. I typically never even run into this need, on one of my tables I have the exact value pulled from LDAP and then an upper cased copy of the value and just reference that. Anyway, that upper thing I have seen bite a couple of people at work more than once, seems to be something they commonly forget about. That and synonyms, no idea why that is.
On Fri, 07 Jan 2005 16:02:09 +0100, RADEMAKERS Tanguy <[EMAIL PROTECTED]> wrote: > >Only problem with that is if you are accessing a table with a lot of > >rows, Oracle ends up doing its upper function on the entire column > >which can slow things down a bit when running the query. > > Look into function based indexes to solve this. Buy the book "Expert > one-on-one Oracle" by Tom Kyte (Wrox/Apress) if you want to unlock the > more powerful features of Oracle (but it should not be your first Oracle > book obviously). If your customer is paying all that money for an Oracle > license, you should be looking at maximizing their return. > > just my 0.02$, > > /t > > > >-----Original Message----- > >From: Aaron Rouse [mailto:[EMAIL PROTECTED] > >Sent: Friday, January 07, 2005 3:30 PM > >To: CF-Talk > >Subject: Re: CF - switching from MS-SQL to Oracle (neq Neo, > >Morpheus, Trin ity) > > > >One thing to keep in mind is Oracle is case sensitive where if I > >remember right MSSQL is not? So something like WHERE BLAH = 'foo' > >returns something different than WHERE BLAH = 'FoO' I know some > >people just do oracles upper function on the BLAH in order to get > >around this, then of course a CF's upper function on the other side. > >Only problem with that is if you are accessing a table with a lot of > >rows, Oracle ends up doing its upper function on the entire column > >which can slow things down a bit when running the query. > > > >-- > >Aaron Rouse > >http://www.happyhacker.com/ > > > >On Fri, 7 Jan 2005 14:19:40 -0000, Robertson-Ravo, Neil (RX) > ><[EMAIL PROTECTED]> wrote: > >> Your queries should be AOK...as long as you are not using any Oracle > >> Specific SQL commands......though really apart from some > >quirky join syntax > >> you should all be good. > >> > >> If you are simply sticking to Insert, delete etc. > >> > >> -----Original Message----- > >> From: Stuart Kidd [mailto:[EMAIL PROTECTED] > >> Sent: 07 January 2005 14:14 > >> To: CF-Talk > >> Subject: CF - switching from MS-SQL to Oracle (neq Neo, > >Morpheus, Trinity) > >> > >> Hi guys, > >> > >> I'm about to start on a new project at my current contract > >for which i've > >> had them buy CF (and for once i didn't take too much convincing). > >> > >> In the past (and present) I connect to an MS-SQL database > >which i've grown > >> to love. > >> > >> At work however, it's all Oracle. I've connected it using the CF > >> Administrator and am using TOAD to add tables etc. > >> > >> Before i start coding i'm wondering if my CFQUERYies will be > >different to > >> those I have created for MS-SQL in anyway? > >> > >> Thanks for your help, > >> > >> Stu > >> > >> ps: also, does anyone know how to create an incremental > >number for an INT in > >> TOAD (it's for an PK id)? > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189648 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
