Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Suggestions for additions to Oracle SQL Language
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.
Received on Thu Apr 11 2002 - 10:18:03 CDT
![]() |
![]() |