Re: Relationals vs. Objects Databases I

In article <orno4KAot6z0Ew29_at_ahardy.demon.co.uk>, Andy Hardy <news1_at_ahardy.demon.co.uk> wrote:
>In article <6am1fp$hsq$1_at_pebble.ml.org>, Joel Garry
><joelga_at_pebble.ml.org> writes
>>In article <2RiBjIAGjkz0EwWz_at_jbdr.demon.co.uk>,
>>Jeremy Rickard <Jeremy_at_SPAM.demon.co.uk> wrote:
>>>In article <6al6n4$gc3$1_at_pebble.ml.org>, Joel Garry
>>><joelga_at_pebble.ml.org> writes
>>>
>>>>Uh, if you have to embed it to get the functionality, then the SQL isn't
>>>>very complete, is it?
>>>
>>>Oh, alright then! SQL isn't a complete programming language. It can't
>>>draw pretty pictures or play pretty sounds (unless perhaps you write
>>>UDF's for it in another language).
>>
>>If all it were lacking were draw and play capabilities, it wouldn't be a
>>bad language.
>>
>
>Fortunately, you are posting to Oracle groups where we do have a
>language embedded in the database that can do just about anything you
>require. Plus some SQL!

Have you followed this thread? Jeremy stated that

>

 Jeremy>>In practice, SQL seems complete enough in my experience.
>>
>

 me>???
>

me>Perhaps you are using SQL to mean the various extended sql's like SQL*Plus?

Jeremy No, I really meant standard SQL. In the sort of work I do, we typically Jeremy embed it in a standard 3GL such as COBOL II, which is quite capable of a Jeremy few iterations and selections if needs be! Cursors tend to be used more Jeremy often than pure set-based SQL.

Jeremy Adding this procedural support to SQL itself would be completely against Jeremy the principles of relational algebra, with seemingly few advantages over Jeremy embedding SQL in a host language.

>Andy

So if you have any disagreements with the statement that standard SQL is complete enough in Jeremy's experience, that disagreement would be with Jeremy.

You may not have noticed I've been posting in Oracle groups since 1989? :)

>
>--
>Andy Hardy. PGP key available on request
>===============================================================

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!