Re: Suggestions for additions to Oracle SQL Language

I think the following simple command would solve all of the problems:

SELECT lots_of_revevant_stuff
FROM some_where_i_cant_identify
BASED ON criteria_i_cant_articulate
WHERE data_entry_mistakes_are_fixed
ORDER BY something_that_will_make_it_look_meaningful;

Perhaps we need the BASED ON clause. ;-)

Daniel Morgan

Thomas Kyte wrote:

> In article <a952qs$d2h8_at_nntp.cig.mot.com>, "Prasad says...
> >
> >I think there were two new keywords added in 9i: ANY and SOME. Look up their
> >usage and see if they satisfy your requirement.
> >
>
> actually any & some have been around for a long long time....
>
> here is going back to 716 (but they predate that as well)
>
> scott_at_ORA716.WORLD> select ename from emp where sal > some ( select sal from emp
> );
>
> ENAME
> ----------
> ALLEN
> WARD...
>
> 13 rows selected.
>
> scott_at_ORA716.WORLD> select ename from emp where sal > any ( select comm from emp
> );
>
> ENAME
> ----------
> SMITH
> ALLEN
> ...
>
> ;)
>
> Me -- I'd like to see the "alter system set cache_hit_ratio = 99.99%" command
> added. Then people would stop asking how to increase their cache hit. Better
> yet:
>
> alter system set <ANY HIT RATIO HERE> = <ANY VALUE YOU WANT>;
>
> and
>
> alter database set fast = true;
>
> or it's friend:
>
> alter database set slow = false;
>
> those are the ones I'm waiting for....
>
> >Prasad Yarlagadda
> >
> >"Basil Jackson" <BJackson_at_BOSGmbH.Com> wrote in message
> >news:adec38b6.0204110718.2074f7f_at_posting.google.com...
> >> 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.
> >
> >
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
Received on Fri Apr 12 2002 - 10:02:44 CDT