Since Oracle 9i Oracle introduced the SQL92 join syntax (inner join, left outer join, right outer join, and full outer join, etc) ... and still supports the old oracle way of outer joins (where x(+)=y).
So, no need to learn new join syntax, it will just work. Kind Regards, Stefan Mueller -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert martin Sent: Wednesday, November 02, 2005 11:30 AM To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] FYI Oracle make free entry level 4Gb userdatabase availalable Hi Just out of interest, how does Oracle do joins ????? Not the standard [INNER / LEFT / RIGHT / OUTER] JOIN TableA ON TableA.a = TableB.a I take it :) Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Jeremy Coulter wrote: >owww....that woudl be nice.....BUT, too much work to change all my joins >to be oracle-ised ;-) > >Jeremy > >-----Original Message----- >From: Paul A Norman <[EMAIL PROTECTED]> >To: NZ Borland Developers Group - Delphi List <[email protected]> >Date: Wed, 2 Nov 2005 10:23:03 +1300 >Subject: [DUG] FYI Oracle make free entry level 4Gb user database availalable > > > >>Stumbled accross this today at: >>www.internetnews.com/dev-news/article.php/3560566<http://www.internetne >>ws.com/dev-news/article.php/3560566> >> http://www.oracle.com/technology/products/database/xe/index.html >> "Oracle Database 10*g* Express Edition (Oracle Database XE) is an >>entry-level, small-footprint database based on the Oracle Database >>10*g*Release 2 code base that's free to develop, deploy, and >>distribute; fast to >>download; and simple to administer. Oracle Database XE is a great >>starter >>database for: >> >> - *Developers* working on PHP, Java, .NET, and Open Source >> applications >> - *DBAs* who need a free, starter database for training and >>deployment >> >> - *Independent Software Vendors (ISVs) and hardware vendors* who >>want >> a starter database to distribute free of charge >> - *Educational institutions and students* who need a free database >>for >> their curriculum >> >>"With Oracle Database XE, currently available as a Beta release for >>Windows >>and Linux, you can now develop and deploy applications with a powerful, >>proven, industry-leading infrastructure, and then upgrade when >>necessary >>without costly and complex migrations. A production release is >>scheduled for >>late 2005. "Oracle Database XE can be installed on any size host >>machine >>with any number of CPUs, but this free version of the world's leading >>database will store up to 4GB of user data, use up to 1GB of memory, >>and use >>one CPU on the host machine. >> dah dah .. .. .. >> >> >> > > >_______________________________________________ >Delphi mailing list >[email protected] >http://ns3.123.co.nz/mailman/listinfo/delphi > > > _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
