Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Suggestions for additions to Oracle SQL Language
I offer no additions to the language but the observation made by a manager
of one of my colleagues
' this database only gives me information I have put into it'. this class of complaint seems common enough so I encourag third party reporting tool suppliers to prodiuce the charts the user wishes to see not those that result from the data - this would have the side effect of speeding up monthly report production several fold.
-- Niall Litchfield Oracle DBA Audit Commission UK "Basil Jackson" <BJackson_at_BOSGmbH.Com> wrote in message news:adec38b6.0204110718.2074f7f_at_posting.google.com...Received on Thu Apr 11 2002 - 16:32:10 CDT
> Often times users tell me things like
> "I deleted some records!"
> "Some records don't make sense!"
> "Many records are no longer needed!"
> etc., etc., etc. you get the point.
>
> Therefore, I would like to suggest that the SQL language be enriched
> by adding two keywords, namely: SOME and MANY
>
> That way, I could use the following commands to resolve the users
> problems...
>
> RESTORE SOME RECORDS TO TABLE xxx;
>
> UPDATE SOME RECORDS IN TABLE xxx SET sense = TRUE;
>
> DELETE MANY RECORDS FROM TABLE xxx;
>
> Wouldn't life be simpler then?
>
> While we're at it, perhaps we could enhance RECOVER DATABASE to
> include
> "SOMETIME BETWEEN 9 AND 10" as an alternative to UNTIL TIME which
> really isn't very user friendly at all.