Re: migrating to oracle

Also LIKE is portable MATCHES is not portable From: "smooth1" <smooth1@iclway.co.uk> > >Also > >SELECT UNIQUE is not portable> >SELECT DISTINCT is portable> >Another FAQ entry.. > >Sujit.Pal@bankofamerica.com wrote in message ><8ptjrn$hra$1@news.xmission.com>... > > > > > > > >Dan > > > >As for app development, you are correct, they are largely similar. > > > >However, Oracle does not have a SET LOCK MODE TO WAIT [n] equivalent, at >least > >AFAIK, so you will have to handle lock waits in the application yourself. >The > >latter is common practice for app development with any database, but >sometimes > >one depends on the Informix SET LOCK MODE TO WAIT [n] feature, because >its >more > >efficient. > > > >HTH > >Sujit > > > > > > > > > > > >dan wright <dw420@nospammepleezairmail.net> on 09/14/2000 11:31:53 PM > > > >Please respond to dan wright <dw420@nospammepleezairmail.net> > > > >To: informix-list@iiug.org > >cc: > >Subject: migrating to oracle > > > > > > > >I just wanted some input from people who have worked primarily in > >Informix, but also at least dabbled w/ Oracle. > > > >I'm not worried about technicalites of importing Informix data into an > >Orcale databsae...I'm more interested in anything of signifigance in > >working w/ Oracle. From my preliminary impressions w/ NetG training CDs > >(which are a waste of money IMnsHO) and reading an O'Reilly PL/SQL book > >- at about 1/10 the cost of NetG's crappy CDs, it is probably 10 times > >more informative. > > > >Anyway, SQL is SQL isn't it? I imagine DBA work will be more different > >than basic app development, but app development will be different > >enough.... > > > >What's your experience? > > > > > > > > > > > > > > > > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.