Re: Suggestions for additions to Oracle SQL Language

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 11 Apr 2002 17:46:11 -0700
Message-ID: <a95aoj06sm@drn.newsguy.com>

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 Thu Apr 11 2002 - 19:46:11 CDT