Re: Suggestions for additions to Oracle SQL Language

Gee why not a

GIVE ME THE DATA I NEED FROM TABLE xxx
:-)

Of course you can do almost all of the things you mentioned in SqlPLus

1: insert into table xxx select * from [backup_table_I_created_with_a_before_delete_trigger_on_my_critical_table_xxx]
2: update xxx set sense = 'TRUE' where ( something = something to id the records )
3: delete from xxx where whatever...

BJackson_at_BOSGmbH.Com (Basil Jackson) wrote:

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

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Thu Apr 11 2002 - 16:06:43 CDT