Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle relational algebra support?
Colin,
True Relational Algebra requires symbols not found in traditional RDBMS packages. They are really only used in college textbooks. The same goes for true Relational Calculus. Instead, you'll have to use the standard SQL commands and constructs such as UNION, INTERSECT, etc. They provide the same exact functionality and are easier to construct and read.
HTH,
Brian
Colin Reinhardt wrote:
>
> You know, the standard relational algebra operations:
>
> select
> (restrict),project,union,intersection,cross-product,division,join,natural-jo
> in...
>
> Van Messner <vmessner_at_bestweb.net> wrote in message
> news:aKGN5.15203$mC.960951_at_monger.newsread.com...
> > What do you mean by "relational algebra"? Oracle supports various
> > arithmetic operators (+ - / *) and set operators MINUS, UNION, INTERSECT
and
> > logical operators (not, and, or) in SQL*Plus.
> >
> >
> > "ColinR" <colinrei_at_oz.net> wrote in message
> > news:t0e8a8fvjeue12_at_corp.supernews.com...
> > > Is there such a thing (add-on?) available? (esp. for the Oracl 8.x
personal
> > > edition?)
> > >
> > > I'm a student studying database systems and we're doing relational
> > > algebra/calculus and I heard something about Oracle having support for
> > > querying using relational algebra syntax, but haven't been able to find
any
> > > facts to corroborate this...
> > >
> > > Thanks,
> > >
> > > Colin Reinhardt
> > >
> > >
> >
> >
-- ======================================== Brian Peasland Raytheons Systems at USGS EROS Data Center These opinions are my own and do not necessarily reflect the opinions of my company! ========================================Received on Tue Nov 07 2000 - 10:02:25 CST
![]() |
![]() |