Re: There are no Oracle gurus!

<sky_diver__at_excite.com> wrote in message news:1106158945.556931.7660_at_c13g2000cwb.googlegroups.com...
>
> DA Morgan wrote:
>> Based on the questions you've asked you might want to seriously
> consider
>> giving this project to someone else.
>
> This is not an answer to the question. In fact none of the respondants
> bothered to answer the OPs question.

I suspect that this is going to be whistling in the wind but hey I'll give it a go.

Yes. The OP (a month before you kicked all this off by the way) got a response from bagieta pointing them to rowid - and a followup from me pointing them to a definition of rowid (whilst giving a brief precis in the post) and suggesting to use sequences.

You may not have got those posts - though even on usenet I'd have expected them to show up by now. You did get Dan's post - you quote from it. Strangely however you don't quote

<quote>You can assign nor use rowd as
rowid is a pseudocolumn: Always has been AFAIK.

To replace identity column you should use a sequence with the number being assigned either in the DML or by means of a BEFORE INSERT trigger </quote>

which *is* of course bothering to answer the OP's question. Someone somewhere was remarking about reading comprehension earlier.

> Oracle schmucks consistantly tell others that they shouldn't try to
> learn Oracle. That Oracle is too difficult and that they should hire
> an Oracle DBA.

Dan also wrote the following

<quote> Oracle doesn't
take kindly to code written where locks escalate, where multiversioning doesn't exist, and where people use temporary tables built on-the-fly.

My recommendation is that you purchase a copy of Tom Kyte's book "Expert one-on-one Oracle" and pay special attention to the first three chapters.</quote>

So recommending to learn Oracle by giving them a reference that actually is aimed at exactly their situation and giving some pertinent advice on what some of the important differences between the posters source and target platforms are, What a negative off-putting post that was.

> So I've come to the conclusion that either
> (A) There are no Oracle gurus.

Of course there aren't. Its a technology not a religion - you don't go and sit at the feet of the master receiving jewels of wisdom - you run it, learn, test, document etc.

> or
> (B) Oracle gurus score very low at reading comprehension.
> Bottom line is... DON'T POST UNLESS YOU CAN ANSWER THE QUESTION!

My bottom line. if you are sorely tempted to abuse someone - try to avoid the temptation. If you really really can't best pick a post that doesn't exhibit the behaviour you accuse them of lacking a month after the event. And don't whatever you do suggest that someone cannot read without in fact reading their post first.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com