Re: Oracle #1? Then why are these still missing...

Good list - hope Oracle sees it and understands our concerns

I believe that 8 - the rename column has been done by Oracle in 8.1 (or what is called 8i)

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
Paul <aspscott_at_tcp.co.uk> wrote in message
news:37a3ee04.700605227_at_news.cix.co.uk...


> When are Oracle going to listen to their users and start to implement

> fundamental requirements which already exist in other RDBMSs.  I am

> sick and tired with Oracle Support saying, "it's a bug, and there are

> no known fixes", "it might be in the next version, but then again it


> might not", "you want me to put in an enhancement request..might take

> 3-5 years though", "it has been asked for before, but we have no plans

> to do it", "you'll have to write a work around", "speak to your

> account manager, he might be able to get it put in, if you are a

> really big corporate customer"

>

> Listen Mr Ellison and your crew, Oracle is still missing basic

> functionality.  So let me suggest something, instead of poncing around

> with new Oracle technologies like Java, why don't you sort out the

> basics first.

>

> Oh and before you read this list and reply: "But this is easy to

> implement" or "I've written something to do this anyway" let me

> explain....so have I had to write / find workarounds for all these.

> But at the end of the day it shouldn't need to happen, it should have

> been in Oracle years ago.  They're fundamental.

>

> 1. A "RANDOM" function.

> 2. A RANDOMIZE function to accompany "RANDOM" function.

> 3. A native "DIV" function.  Oracle has MOD an integer remainder

> function but not an integer division function.  DIV and MOD always

> appear together, but not in Oracle.

> 4. Bitwise boolean functions OR, XOR, AND, NOT (not the same as

> boolean operators).  Ever tried to write a decent encryption algorithm

> in Oracle without these?  Ever tried to mask an integer to see if a

> bit is set? Just overload the existing boolean operators to allow

> Bitwise boolean opeartions.

> 5. TO_HEX function.  Are they stupid or what?

> 6. TO_BASE function which can handle bases up to 64.

> 7. A variant of REPLACE that only replaces the first instance of

> search_string found. Come on Oracle simply overload it and add another

> parameter Max_Replaces (Max_Replaces > 0).

> 8. Alter Table RENAME COLUMN .... How bloody obvious is this?  How

> many times do you need to be asked?  OK you have constraints to

> consider but they know this.  We don't like using the data-dictionary

> hack.

> 9. Constraint fk_MyForeignKey References MyOtherTable (MyPKField) ON

> UPDATE CASCASE.  Is Oracle the only RDBMS that doesn't have a native

> on update cascade?

> 10. Constraint fk_MyForeignKey References MyOtherTable (MyPKField) ON

> DELETE SET NULL.  Another Oracle gotcha.  It is basic referential

> principles.  Every single DB design case tool has this but oh no not

> Oracle, it is far too obvious for them.

> 11. The ability to find out who is the locker when using pessimistic

> locking (e.g. when "select 1 from MYTable where MyPrimaryKey = MyValue

> for update nowait" fails because someone else has already

> pessimistically locked it.)

> 12 The ability to move the cursor back to correct typos in SQL plus.

> Why is it still not possible?  Sometimes we haven't gone into another

> editor and we accidentally make a typo at the end of a 200 character

> line, so Oracle makes us retype the whole lot again.  SQL Plus is and

> always has been an extremely poor interface.

> 13 Polymorphism in Objects.  What other object modeling language

> doesn't have Polymorphism?  derrrrr

> 14. Binary operator XOR.

> 15. Give SQL Loader the ability to skip columns in CSV format.  Not

> all fields in a CSV file may be needed Oracle, so come on.

> 16 Allow Oracle Debugger Probe to watch of implicit loop variables.

> 17. Allow "OR REPLACE" syntax on all create object commands.

> etc. etc. etc.

>

> I could continue, but I'm sure others will add to this.

>

> Kind regards

> Paul Scott

> aspscott_at_tcp.co.uk

> ^^ remove 'as' anti-spam prefix to E-mail

>