Question for you Oracle Guru's -- conversion of SQL to Ora

[Guest]

I have been tasked with converting a MS SQL 2000 db to Oracle 10g. I am
the one that will be writing the updates to the table structures,
taking existing sp's and moving them to pl/sql. My problem is I have
not done this in a good number of years, converting sql to ora, and I
frankly am stuck on how to deal with ms's use of identity columns in a
table. I know RowId exists in Oracle but I have forgotten how to use
it, i.e. do I have to maintain a sequence in pl/sql to use it?

The question I am getting to is what is the best source of readily
viewable information on the different datatypes in each system and how
they equate to each other. Also, what do you use to ensure uniqueness
in a table in ora such that ms sql2000 uses an identity column.
Any help is greatly appreciated.

[bagieta]

I'm not a Oracle guru, but I use rowid sometimes and can tell you about it
that what I know.

table. I know RowId exists in Oracle but I have forgotten how to use it, i.e. do I have to maintain a sequence in pl/sql to use it?

No you don't have to use any sequence.
You can use rowid in query just like identity:

MSSQL - select @@identity, t.* from table t
ORACLE - select rowid, t.* from table t

you can do now something like

update table
set
col1 = :col1,
col2 = :col2
where
rowid = :old_rowid

Remember that rowid is unique for the given query (it is not like oid in
postgresql - unique for any table tuple). So when you finish your
transaction and then call SELECT once again then the rowid value will be
different.



--
Regards Bagieta
~~~~~~~~~~~~~~~~~~~~~~~~~~~
dbDeveloper - Multiple databases editor
http://www.prominentus.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~

[Daniel Morgan]

oai@bigfoot.com wrote:
I have been tasked with converting a MS SQL 2000 db to Oracle 10g. I am the one that will be writing the updates to the table structures, taking existing sp's and moving them to pl/sql. My problem is I have not done this in a good number of years, converting sql to ora, and I frankly am stuck on how to deal with ms's use of identity columns in a table. I know RowId exists in Oracle but I have forgotten how to use it, i.e. do I have to maintain a sequence in pl/sql to use it? The question I am getting to is what is the best source of readily viewable information on the different datatypes in each system and how they equate to each other. Also, what do you use to ensure uniqueness in a table in ora such that ms sql2000 uses an identity column. Any help is greatly appreciated.

Based on the questions you've asked you might want to seriously consider
giving this project to someone else. 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.

As for the code I would suggest you rewrite from scratch. 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.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

[Niall Litchfield]

"bagieta" <bagieta21@poczta.onet.pl> wrote in message
news:cqa3el$ch0$1@opal.icpnet.pl... I'm not a Oracle guru, but I use rowid sometimes and can tell you about it that what I know. table. I know RowId exists in Oracle but I have forgotten how to use it, i.e. do I have to maintain a sequence in pl/sql to use it? No you don't have to use any sequence. You can use rowid in query just like identity: MSSQL - select @@identity, t.* from table t ORACLE - select rowid, t.* from table t you can do now something like update table set col1 = :col1, col2 = :col2 where rowid = :old_rowid Remember that rowid is unique for the given query (it is not like oid in postgresql - unique for any table tuple). So when you finish your transaction and then call SELECT once again then the rowid value will be different.

Not *will* be different. *might* be different. Rowid is effectively a
pointer to the physical location of the row. If the row *moves* then its
rowid will change, if it doesn't it won't.
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/datatype.htm#sthref3893

sequences are the mechanism for achieving the equivalent of identity (ie a
guaranteed unique key).


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

[Murray Sobol]

Check out this link:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx

Murray

"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:41c8c8e6$1_3@127.0.0.1... oai@bigfoot.com wrote: I have been tasked with converting a MS SQL 2000 db to Oracle 10g. I am the one that will be writing the updates to the table structures, taking existing sp's and moving them to pl/sql. My problem is I have not done this in a good number of years, converting sql to ora, and I frankly am stuck on how to deal with ms's use of identity columns in a table. I know RowId exists in Oracle but I have forgotten how to use it, i.e. do I have to maintain a sequence in pl/sql to use it? The question I am getting to is what is the best source of readily viewable information on the different datatypes in each system and how they equate to each other. Also, what do you use to ensure uniqueness in a table in ora such that ms sql2000 uses an identity column. Any help is greatly appreciated. Based on the questions you've asked you might want to seriously consider giving this project to someone else. 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. As for the code I would suggest you rewrite from scratch. 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. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond) -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==---------- http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

[Guest]

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.

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.

So I've come to the conclusion that either
(A) There are no Oracle gurus.
or
(B) Oracle gurus score very low at reading comprehension.
Bottom line is... DON'T POST UNLESS YOU CAN ANSWER THE QUESTION!

[James K]

I agree with you.
I saw here many questions with that kind of stupid answers.
I always asked myself why someone answer that. It is better not to
answer at all and let it to do someone else.

[Daniel Morgan]

sky_diver_@excite.com wrote:
DA Morgan wrote:Based on the questions you've asked you might want to seriously considergiving 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. 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. So I've come to the conclusion that either (A) There are no Oracle gurus. or (B) Oracle gurus score very low at reading comprehension. Bottom line is... DON'T POST UNLESS YOU CAN ANSWER THE QUESTION!

So why didn't you provide the helping hand instead of criticizing my
response? Reminds me very much of a few of my favorite quotes:

Critics are like eunuchs in a harem; they know how it's done, they've
seen it done every day, but they're unable to do it themselves.
~ Brendan Behan

Any fool can criticise - and many of them do.
~ Cyril Garbett

A critic's symbol should be the tumble-bug: he deposits his eggs in
somebody else's dung, otherwise he could not hatch it.
~ Mark Twain

But having now vented my fury I will give you a more appropriate
response.

It would be unethical in many situations to help someone. That
might be because they are cheating on school work, it might be
because they are perceived as being dangerous. It would be
totally irresponsible for me, or anyone else here, to advise
someone on how to break into a system or how to recover from a
service loss where the OP's inability to follow the directions,
or appreciate nuances, might cause more harm than good.

Being responsible means that when someone asks how to properly sight
in their rifle you make sure it isn't aimed at someone else's head.

Our perception was clearly that trying to help this person was not
the responsible thing to do.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[natex]

"Bagieta" <user@example.net> wrote in message
news:csmcu7$i3o$1@news.onet.pl...I agree with you. I saw here many questions with that kind of stupid answers. I always asked myself why someone answer that. It is better not to answer at all and let it to do someone else.
DA Morgan wrote: Based on the questions you've asked you might want to seriously
consider giving this project to someone else.


Well, Bagieta is correct, and if you really want second opinion: you really
should give that project to someone else.

[IANAL_VISTA]

Bagieta <user@example.net> wrote in news:csmcu7$i3o$1@news.onet.pl:
I agree with you. I saw here many questions with that kind of stupid answers. I always asked myself why someone answer that. It is better not to answer at all and let it to do someone else.

pot <=> kettle <=> black

[Rauf Sarwar]

sky_diver_@excite.com wrote: 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.
<snip>

Did you even bother to read Daniel's post past the first paragraph?

I see his first response as equal to a response given to someone
asking... how do I perform brain surgery on a patient. You would
initially say.... let a real brain surgeon do it but if you must...
atleast pick up "Brain surgery 101" and read first 3 chapters.
Regards
/Rauf

[Guest]

>So why didn't you provide the helping hand instead ofcriticizing my response?

Because (A) I don't pretend to be an Oracle expert
and (B) you needed the criticism.

I've been reading Oracle topics in newsgroups for a couple of months
now and I have found little to no useful information in all that text.
Most respondants either tell you to hire a DBA, go back to school, or
try to change the subject.
It would be unethical in many situations to help someone.That might be because they are cheating on school work,it might be because they are perceived as being dangerous.It would be totally irresponsible for me, or anyone else here,to advise someone on how to break into a system or how torecover from a service loss where the OP's inability to followthe directions, or appreciate nuances, might cause moreharm than good.

Good Gracious - What a cop-out!
This is what I'm talking about! Do they teach those excuses in Oracle
school? I've been programming (databases included) since before Oracle
existed and I have never taken that holier-than-thou attitude of yours
with anyone who has asked for assistance.

It's sad really. One just doesn't see the willfull exchange of
information as found in other technologies.

I suppose it was rather impulsive of me to write this - I just can't
figure out if the Oracle experts are rude or just ignorant.
Sorry to the OP since I wasn't helpful with these posts.

[Ed prochak]

I saw reference to a good web page that tried to compare ORACLE and
other DBMS. Try a google search in comp.databases It was fairly recent
(last few months) but I must have bookmarked it at home (obviously I'm
at work now)

You might also ask this in that group since this isn't really an ORACLE
specific question.

HTH,
ed

[Ed prochak]

sky_div...@excite.com wrote:So why didn't you provide the helping hand instead ofcriticizing my response? Because (A) I don't pretend to be an Oracle expert and (B) you needed the criticism.

for (A)
the question wasn't about ORACLE, the bottom line question was about
comparing datatypes across DBMS. His best answers would likely come in
a more appropriate group like comp.databases, not here.
for (B)
If you browsed back a bit, you'd see that the regulars have all
received this critism before. It's just not needed. I've been reading Oracle topics in newsgroups for a couple of months now and I have found little to no useful information in all that
text. Most respondants either tell you to hire a DBA, go back to school, or try to change the subject.

Daniel can be harsh at times, but he has seen a LOT of the crap
produced by ORACLE wannabes, who try to jump from using MS ACCESS or
SQL Server. And there are definitely a significant number of students
that try to get their work done for them here.

I will say this about recent threads. The quality of the Questions
seems to have gone way down. And even when we have replied trying to
get more information so we can help, the original poster seldom
replies. I wonder more and more if posters think this is a chat room
where the replies will come in seconds or minutes instead of hours or
days. When they see no response after a few minutes, they walk away.

It's sad really. One just doesn't see the willfull exchange of information as found in other technologies.

Maybe that's why the users of ACCESS seldom even understand the
technology they use, because they just get code samples handed to them,
instead of the ideas and principles needed to solve the problem. I suppose it was rather impulsive of me to write this - I just can't figure out if the Oracle experts are rude or just ignorant. Sorry to the OP since I wasn't helpful with these posts.

It would be nice to hear some feedback from the OP.

One readers rude is another's measured, respectful reply. What you read
into a post is up to you.

Meanwhile I suggest you keep reading here. Judge the answers in the
context of the questions (and other spam that's made its way into
here). One good question will often get a stream of good answers.
have a nice day.
Ed

[Daniel Morgan]

sky_diver_@excite.com wrote:
So why didn't you provide the helping hand instead ofcriticizing my response? Because (A) I don't pretend to be an Oracle expert and (B) you needed the criticism. I've been reading Oracle topics in newsgroups for a couple of months now and I have found little to no useful information in all that text. Most respondants either tell you to hire a DBA, go back to school, or try to change the subject.

Most responses either point to a reference with the solution or provide
the code or sufficiently large a hint to solve the problem.

And as someone else has pointed out ... if those like you bothered to
read past the first sentence you'd have seen that I did, in fact,
provide a complete answer.
It would be unethical in many situations to help someone.That might be because they are cheating on school work,it might be because they are perceived as being dangerous.It would be totally irresponsible for me, or anyone else here,to advise someone on how to break into a system or how torecover from a service loss where the OP's inability to followthe directions, or appreciate nuances, might cause moreharm than good. Good Gracious - What a cop-out!

Re-read the first sentence you wrote:

"(A) I don't pretend to be an Oracle expert"

Yet you feel fully qualified to comment on the rationale behind
their thinking. Do you run around hospitals criticizing surgeons
when they advise a patient against a risky surgical procedure too?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

[Daniel Morgan]

Ed Prochak wrote:
I will say this about recent threads. The quality of the Questions seems to have gone way down. And even when we have replied trying to get more information so we can help, the original poster seldom replies. I wonder more and more if posters think this is a chat room where the replies will come in seconds or minutes instead of hours or days. When they see no response after a few minutes, they walk away.

I've noticed the same thing and wonder whether these people think
because some of us are regulars that we are paid to do this.

For the record ... we do this because we enjoy it ... we don't get paid
and in fact pay money for the ability, just like you, to connect to the
internet and do this ... and third all but one or two of us do NOT work
for Oracle Corp. and feel free to criticize Oracle, criticize posts,
go on about David Bowie, or do whatever we feel like at any particular
moment in time.

What has never been pointed out before is how few people, having had
their bacon pulled out of the fire, ever come back and say "Thank you."
Few do and it is noted and appreciated but most do not. And yet we are
the ones that are rude: Such is life.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Guest]

Ed Prochak wrote: for (B) If you browsed back a bit, you'd see that the regulars have all received this critism before. It's just not needed.

Obviously it WAS needed.
Daniel can be harsh at times, but he has seen a LOT of the crap produced by ORACLE wannabes, who try to jump from using MS ACCESS or SQL Server.

There's that holier-than-thou attitude again. Is there such thing as
an Oracle wannabes? Or is this just Oracle users inflating their own
self-worth.
And there are definitely a significant number of students that try to get their work done for them here.

And who really cares. Its not their job to ensure that students aren't
cheating. That is just another cheap excuse used by people who don't
know the answer.
I will say this about recent threads. The quality of the Questions seems to have gone way down.

Just simply puts them on par with the quality of answers.
Meanwhile I suggest you keep reading here. Judge the answers in the context of the questions (and other spam that's made its way into here). One good question will often get a stream of good answers. have a nice day. Ed

Thanks Ed, but I think I will move on to where there is more exchanging
of ideas and less ego massaging.

[Guest]

DA Morgan wrote: sky_diver_@excite.com wrote: "(A) I don't pretend to be an Oracle expert" Yet you feel fully qualified to comment on the rationale behind their thinking. Do you run around hospitals criticizing surgeons when they advise a patient against a risky surgical procedure too?

So now you equate your silly database knowledge with that of a surgeon.
Wake up. You work with a DBMS - BIG DEAL! Experience in Oracle is
not that special.

[Guest]

DA Morgan wrote: I've noticed the same thing and wonder whether these people think because some of us are regulars that we are paid to do this. For the record ... we do this because we enjoy it ... we don't get
paid and in fact pay money for the ability, just like you, to connect to
the internet and do this ... and third all but one or two of us do NOT
work for Oracle Corp. and feel free to criticize Oracle, criticize posts, go on about David Bowie, or do whatever we feel like at any
particular moment in time. What has never been pointed out before is how few people, having had their bacon pulled out of the fire, ever come back and say "Thank
you." Few do and it is noted and appreciated but most do not. And yet we
are the ones that are rude: Such is life. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)

You want some cheese to go with that whine?

You want thanks? For what? For your snide remarks an insults that
serve no other purpose than to make YOU feel better about yourself?

Hey, if you're not getting the appreciation you THINK you deserve, then
stop offering advice. You make this so much more complicated than it
needs to be.

[Daniel Morgan]

sky_diver_@excite.com wrote:
Obviously it WAS needed. There's that holier-than-thou attitude again. And who really cares. Its not their job to ensure that students aren't cheating. That is just another cheap excuse used by people who don't know the answer. Thanks Ed, but I think I will move on to where there is more exchanging of ideas and less ego massaging.

Please do ... the only thing you have contributed to this group so
far could have been contributed by any infant or toddler: Whining.

And any time you get a chance to look in the mirror: Seriously
consider the implications of the first two quotes from you above.
The juxtaposition is most enlightening. Sure is.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Daniel Morgan]

sky_diver_@excite.com wrote:
DA Morgan wrote:sky_diver_@excite.com wrote:"(A) I don't pretend to be an Oracle expert"Yet you feel fully qualified to comment on the rationale behindtheir thinking. Do you run around hospitals criticizing surgeonswhen they advise a patient against a risky surgical procedure too? So now you equate your silly database knowledge with that of a surgeon. Wake up. You work with a DBMS - BIG DEAL! Experience in Oracle is not that special.

Except that you don't have it.

But don't play childish games trying to change the subject. The
point being made was that you feel free to criticize those that
have an expertise that you lack. Isn't there an MS Access usenet
group you'd feel more comfortable in?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Volker Hetzer]

<sky_diver_@excite.com> schrieb im Newsbeitrag news:1106585722.244393.253900@c13g2000cwb.googlegroups.com... Ed Prochak wrote: for (B) If you browsed back a bit, you'd see that the regulars have all received this critism before. It's just not needed. Obviously it WAS needed. Daniel can be harsh at times, but he has seen a LOT of the crap produced by ORACLE wannabes, who try to jump from using MS ACCESS or SQL Server. There's that holier-than-thou attitude again. Is there such thing as an Oracle wannabes?
Maybe not, but there are a lot oracle "mustabes". The standard
situation is that somebone buys an expensive piece of software, the
admin gets it dumped on his desk, discovers that it needs oracle
and the boss authorizes him to order the CDs.
Then the poor admin shows up here and asks "ow to run oracle"
There's no way that we can tell him this in a couple of articles.
The only reasonable way to save the expensive app is to give that
admin enough verbal ammo that he can convince his boss to pay
for the 10d admin course. Or to let the admin bother about
the software and hire someone for dealing with the database issues.
And there are definitely a significant number of students that try to get their work done for them here. And who really cares. Its not their job to ensure that students aren't cheating.
It's not their job to help others run their databases either.
OTOH, if they *assume* that responsibility, out of niceness and free
will, they can go about it in any way they want. And if they want to
help people help themselves and not just hand out dangerous stuff without
knowing all the facts (as is typical if you are asked here), it's their
choice.
That is just another cheap excuse used by people who don't know the answer.
Any evidence for this?

[Guest]

"It's not their job to help others run their databases either.
OTOH, if they *assume* that responsibility, out of niceness and free
will, they can go about it in any way they want. And if they want to
help people help themselves and not just hand out dangerous stuff
without
knowing all the facts (as is typical if you are asked here), it's their
choice."

That's very arrogant to assume that *they* are helping others to do
anything other than expand their knowledge in Oracle. Is that little
boy Morgan's motivation? Does he get his kicks out of thinking he's
the one that makes the world go 'round?

<sarcasm>Well when is he going to get the Nobel Prize for keeping the
world safe from test cheaters and all that *dangerous stuff* in
Oracle.</sarcasm>

[Guest]

DA Morgan wrote: sky_diver_@excite.com wrote: DA Morgan wrote:sky_diver_@excite.com wrote:>"(A) I don't pretend to be an Oracle expert"Yet you feel fully qualified to comment on the rationale behindtheir thinking. Do you run around hospitals criticizing surgeonswhen they advise a patient against a risky surgical procedure too? So now you equate your silly database knowledge with that of a
surgeon. Wake up. You work with a DBMS - BIG DEAL! Experience in Oracle is not that special. Except that you don't have it. But don't play childish games trying to change the subject.

Ha! That's your tactic.
And for all the knowledge you THINK you have, you don't know Jack about
me.
Remember this thread is about YOU and your lack of professionalism.
The fact that you continue this childish banter of yours indicates that
you are far too concerned with you bruised ego.

As far as I'm concerned, this is over. Go get yourself a glass of milk
and take a few deep breaths.

[Volker Hetzer]

<sky_diver_@excite.com> schrieb im Newsbeitrag news:1106662740.844071.243050@f14g2000cwb.googlegroups.com... "It's not their job to help others run their databases either. OTOH, if they *assume* that responsibility, out of niceness and free will, they can go about it in any way they want. And if they want to help people help themselves and not just hand out dangerous stuff without knowing all the facts (as is typical if you are asked here), it's their choice." That's very arrogant to assume that *they* are helping others to do anything other than expand their knowledge in Oracle.
Why? Have you met them? Did they tell you anything else?
Is that little boy Morgan's motivation? Does he get his kicks out of thinking he's the one that makes the world go 'round?
No idea. Could be. Some people are that way. Some remember their
newbie days. Some have other reasons. I don't care.
<sarcasm>Well when is he going to get the Nobel Prize for keeping the world safe from test cheaters and all that *dangerous stuff* in Oracle.</sarcasm>
I don't know but I *do* know what my boss would say if I'd botched
our production database because I did something "some guy from
usenet" told me to. If that guy from usenet reminds me of that sometimes
I'm thankful.

Volker

[Daniel Morgan]

sky_diver_@excite.com wrote:
"It's not their job to help others run their databases either. OTOH, if they *assume* that responsibility, out of niceness and free will, they can go about it in any way they want. And if they want to help people help themselves and not just hand out dangerous stuff without knowing all the facts (as is typical if you are asked here), it's their choice." That's very arrogant to assume that *they* are helping others to do anything other than expand their knowledge in Oracle. Is that little boy Morgan's motivation? Does he get his kicks out of thinking he's the one that makes the world go 'round?

No but I do believe I have something to contribute to the world
more important than your useless and childish rants. You have
contributed nothing to c.d.o.tools except noise and whining. If you
see yourself as something more than a self-indulgent 20 year old
why don't you go back and answer the OP's question. No doubt you
are capable of using google and finding the answer. Or is that
expecting too much of you?
<sarcasm>Well when is he going to get the Nobel Prize for keeping the world safe from test cheaters and all that *dangerous stuff* in Oracle.</sarcasm>

In case you are as ignorant about this group as you seemingly are
about Oracle and acting like an adult ... this is a usenet group
and no one here is paid to post anything. Those that are here are
doing so because they wish to be and are constrained in what they
post by nothing but their own choices. If you don't like my choices
then go elsewhere or ignore them. But I really couldn't care less what
you think about this or any other topic and have now added you to my
killfile joining the likes of the bad egg omlet.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Steve Baldwin]

"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1106675804.563597@yasure... sky_diver_@excite.com wrote: "It's not their job to help others run their databases either. OTOH, if they *assume* that responsibility, out of niceness and free will, they can go about it in any way they want. And if they want to help people help themselves and not just hand out dangerous stuff without knowing all the facts (as is typical if you are asked here), it's their choice." That's very arrogant to assume that *they* are helping others to do anything other than expand their knowledge in Oracle. Is that little boy Morgan's motivation? Does he get his kicks out of thinking he's the one that makes the world go 'round? No but I do believe I have something to contribute to the world more important than your useless and childish rants. You have contributed nothing to c.d.o.tools except noise and whining. If you see yourself as something more than a self-indulgent 20 year old why don't you go back and answer the OP's question. No doubt you are capable of using google and finding the answer. Or is that expecting too much of you? <sarcasm>Well when is he going to get the Nobel Prize for keeping the world safe from test cheaters and all that *dangerous stuff* in Oracle.</sarcasm> In case you are as ignorant about this group as you seemingly are about Oracle and acting like an adult ... this is a usenet group and no one here is paid to post anything. Those that are here are doing so because they wish to be and are constrained in what they post by nothing but their own choices. If you don't like my choices then go elsewhere or ignore them. But I really couldn't care less what you think about this or any other topic and have now added you to my killfile joining the likes of the bad egg omlet. -- Daniel A. Morgan

Oh! Interesting to see Daniel pissing off even the Oracle DBA's (in addition
to his trolling on the DB2 newsgroup).

[Ed prochak]

sky_diver_@excite.com wrote: "It's not their job to help others run their databases either. OTOH, if they *assume* that responsibility, out of niceness and free will, they can go about it in any way they want. And if they want to help people help themselves and not just hand out dangerous stuff without knowing all the facts (as is typical if you are asked here), it's
their choice." That's very arrogant to assume that *they* are helping others to do anything other than expand their knowledge in Oracle. Is that little boy Morgan's motivation? Does he get his kicks out of thinking he's the one that makes the world go 'round?

Daniel seems motivated much like me. I like to help other learn, in a
dialog with some back and forth. I do not enjoy spool feeding
information to others. Few people post replies of thanks (yes the
answers helped), but even fewer post replies of ingratitude (no, that
answer didn't help).

Sadly, the vast majority give no reply either way. I'd say the ratio of
thanks to ingratitude is very high. So I do not think it's arrogant. <sarcasm>Well when is he going to get the Nobel Prize for keeping the world safe from test cheaters and all that *dangerous stuff* in Oracle.</sarcasm>

It's not the DB that is dangerous.

[Daniel Morgan]

Mark A wrote:
Oh! Interesting to see Daniel pissing off even the Oracle DBA's (in addition to his trolling on the DB2 newsgroup).

If you think he is an Oracle DBA they by all means court him as
a potential customer for your company: IBM. You can have him with
my most sincere wish for a long and happy relationship.

BTW: Mark and I only post at c.d.ibm-db2 when there is specific
mention of Oracle. Is there something in the above that makes you
think that as an IBM employee promoting DB2 that this related to
you? Or having discovered the word "troll" did you decide to become
one yourself to see if it suits you? It doesn't. Please extend the
same courtesy here as we extend to you.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Steve Baldwin]

"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1106678635.160128@yasure...
on the DB2 newsgroup). If you think he is an Oracle DBA they by all means court him as a potential customer for your company: IBM. You can have him with my most sincere wish for a long and happy relationship. BTW: Mark and I only post at c.d.ibm-db2 when there is specific mention of Oracle. Is there something in the above that makes you think that as an IBM employee promoting DB2 that this related to you? Or having discovered the word "troll" did you decide to become one yourself to see if it suits you? It doesn't. Please extend the same courtesy here as we extend to you. -- Daniel A. Morgan

IBM is not my company. I am not an IBM employee. I am an independent
consultant.

[Daniel Morgan]

Mark A wrote:
"DA Morgan" <damorgan@x.washington.edu> wrote in message news:1106678635.160128@yasure... on the DB2 newsgroup).If you think he is an Oracle DBA they by all means court him asa potential customer for your company: IBM. You can have him withmy most sincere wish for a long and happy relationship.BTW: Mark and I only post at c.d.ibm-db2 when there is specificmention of Oracle. Is there something in the above that makes youthink that as an IBM employee promoting DB2 that this related toyou? Or having discovered the word "troll" did you decide to becomeone yourself to see if it suits you? It doesn't. Please extend thesame courtesy here as we extend to you.--Daniel A. Morgan IBM is not my company. I am not an IBM employee. I am an independent consultant.

I stand corrected. Now can we get your agreement to equal courtesy?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Steve Baldwin]

"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1106686865.906177@yasure... I stand corrected. Now can we get your agreement to equal courtesy? -- Daniel A. Morgan

I am sorry, but I don't understand what you are talking about.

[Daniel Morgan]

Mark A wrote:
"DA Morgan" <damorgan@x.washington.edu> wrote in message news:1106686865.906177@yasure...I stand corrected. Now can we get your agreement to equal courtesy?--Daniel A. Morgan I am sorry, but I don't understand what you are talking about.

Mark and I, and I think all other regulars in c.d.o.server NEVER
post to c.d.ibm-db2 except when a previously existing thread
specifically mentions Oracle. I am asking the same courtest from
you with respect to Oracle.

That we not have unsolicited comments about DB2 here unless they
are directly responsive to an existing thread that involves DB2.

It is just a matter of courtesy started, as I have pointed out
repeatedly, by someone who shall remain anonymous, that posted
an unsolicited promotion for DB2 (some might call it spam) at
comp.databases.oracle.

So please agree and lets end this thread.

Thanks.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Steve Baldwin]

"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1106697970.573261@yasure...I stand corrected. Now can we get your agreement to equal courtesy?--Daniel A. Morgan I am sorry, but I don't understand what you are talking about. Mark and I, and I think all other regulars in c.d.o.server NEVER post to c.d.ibm-db2 except when a previously existing thread specifically mentions Oracle. I am asking the same courtest from you with respect to Oracle. That we not have unsolicited comments about DB2 here unless they are directly responsive to an existing thread that involves DB2. It is just a matter of courtesy started, as I have pointed out repeatedly, by someone who shall remain anonymous, that posted an unsolicited promotion for DB2 (some might call it spam) at comp.databases.oracle. So please agree and lets end this thread. Thanks. -- Daniel A. Morgan

I was under the impression that you did not work for Oracle, so I am
confused. I am an independent consultant who has experience with Oracle and
DB2 and I have a right to post in this newsgroup or any newsgroup

Since you apparently posted the exact same information as me (but you added
your own editorial comment, which I did not) I don't understand what you are
complaining about.

But maybe part of my confusion is that your next to last paragraph was
apparently written in haste and doesn't make much sense to me.

[Daniel Morgan]

Mark A wrote:
"DA Morgan" <damorgan@x.washington.edu> wrote in message news:1106697970.573261@yasure...>I stand corrected. Now can we get your agreement to equal courtesy?>-->Daniel A. MorganI am sorry, but I don't understand what you are talking about.Mark and I, and I think all other regulars in c.d.o.server NEVERpost to c.d.ibm-db2 except when a previously existing threadspecifically mentions Oracle. I am asking the same courtest fromyou with respect to Oracle.That we not have unsolicited comments about DB2 here unless theyare directly responsive to an existing thread that involves DB2.It is just a matter of courtesy started, as I have pointed outrepeatedly, by someone who shall remain anonymous, that postedan unsolicited promotion for DB2 (some might call it spam) atcomp.databases.oracle.So please agree and lets end this thread.Thanks.--Daniel A. Morgan I was under the impression that you did not work for Oracle, so I am confused.

I don't and never have. But why is agreeing to simple courtesy so
difficult for you?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Steve Baldwin]

"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1106761311.30050@yasure... I don't and never have. But why is agreeing to simple courtesy so difficult for you? -- Daniel A. Morgan

I don't understand the so called "courtesy" you are talking about. Your post
had some grammatical errors and did not make any sense to me.

If I have done something you don't like, please be specific.

[Daniel Morgan]

Mark A wrote:
"DA Morgan" <damorgan@x.washington.edu> wrote in message news:1106761311.30050@yasure...I don't and never have. But why is agreeing to simple courtesy sodifficult for you?--Daniel A. Morgan I don't understand the so called "courtesy" you are talking about. Your post had some grammatical errors and did not make any sense to me. If I have done something you don't like, please be specific.

My apology for each and every typographical and grammatical
error made here, there, or everywhere. This is bloody meaningless
and I can't believe you are prolonging it so I am kill filing the
thread.

I have simply asked you to be courteous. To not post unsolicited
comments about DB2 in an Oracle usenet group except in response
to an existing thread that refers to DB2.

If you can not understand this due to some English to English
translation problem then please just let it drop.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Steve Baldwin]

"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1106766332.755125@yasure... My apology for each and every typographical and grammatical error made here, there, or everywhere. This is bloody meaningless and I can't believe you are prolonging it so I am kill filing the thread. I have simply asked you to be courteous. To not post unsolicited comments about DB2 in an Oracle usenet group except in response to an existing thread that refers to DB2. If you can not understand this due to some English to English translation problem then please just let it drop. -- Daniel A. Morgan

I am a DBA who uses both DB2 and Oracle (although I will admit that I work
more with DB2). I don't need to wait for someone to ask me (or solicit me)
before I post to an Oracle thread.

The post I made concerned a TPC benchmark (an organization which Oracle is
an enthusiastic and long-standing member) which specifically included
information about Oracle, both in the subject and the text of my post.

Unbeknownst to me, you posted the exact same information (along with your
editorial comments about IBM) in the same newsgroup before I did. So your
comments are "solicited" and mine are "not solicited"? This is shear
hypocrisy, and not very courteous.

BTW, I was not criticizing your grammar or typographical errors just to be
argumentative. Your statements simply made no sense to me, and I asked for
clarification or rewording (without the errors) so that I could understand
what you are talking about.

[Alex Molochnikov]

Mark,

I have been watching this thread for a while, wondering at what point it
will become clear to you that you are dealing with a person suffering from a
compulsive obsessive disorder. Your opponent took upon himself the functions
of an internet cop, guarding the purity of the newsgroups that he truly
believes to be his fiefdom.

He lashes out to everyone whose posts, for one reason or another, do not fit
with surgical precision in the NG's chapter, and that is subject to his own
interpretation. That happened to me a while ago, when I posted a request for
assistance in beta-testing our program - he responded with abuse similar to
what I see in other threads that suffered his "contributions".

Of course, you are free to continue this thread - just keep in mind that you
are entertaining someone who has too much free (but paid for) time on his
hands, and needs to feed his obsession.

Alex Molochnikov

[Steve Baldwin]

"Alex Molochnikov" <NOBODY@NOSPAM.COM> wrote in message
news:8vUJd.182052$6l.88015@pd7tw2no... Mark, I have been watching this thread for a while, wondering at what point it will become clear to you that you are dealing with a person suffering from
a compulsive obsessive disorder. Your opponent took upon himself the
functions of an internet cop, guarding the purity of the newsgroups that he truly believes to be his fiefdom. He lashes out to everyone whose posts, for one reason or another, do not
fit with surgical precision in the NG's chapter, and that is subject to his
own interpretation. That happened to me a while ago, when I posted a request
for assistance in beta-testing our program - he responded with abuse similar
to what I see in other threads that suffered his "contributions". Of course, you are free to continue this thread - just keep in mind that
you are entertaining someone who has too much free (but paid for) time on his hands, and needs to feed his obsession. Alex Molochnikov
Thanks Alex. I had pretty much come to the same conclusion myself.

[Niall Litchfield]

<sky_diver_@excite.com> wrote in message
news:1106158945.556931.7660@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

[Ed prochak]

Alex,
please be complete in your descriptions. You got no lashes for posting
off topic. You were lashed for repeatedly posting off topic when you
were informaed of the correct group to post.

Sorry if you still have bad feelings about it. But I searched this
group in google again to be sure.
Yes, you have posted nothing here except your spam and now this lash
out at Daniel.

Try to contribute something other than advertising your wares. Maybe
then you'll build up some respect.
ed