Re: migrating to oracle

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?

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? > > > > > > >