|
|
|
|
|
Re: New sticky in the Newbie board! [message #227068 is a reply to message #227031] |
Tue, 27 March 2007 04:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
I'd say no.
If you look at the thread that lead to this discussion, you can see the OP ended up with a 'select top 5 salary' solution, which is a SQLServer/Sybase only solution.
I think accepting specific non-Oracle solutions only adds to the confusion. People will add non-Oracle questions without mentioning that fact. In my view, Barbara's solution is the best.
|
|
|
Re: New sticky in the Newbie board! [message #227225 is a reply to message #227031] |
Tue, 27 March 2007 10:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/43710.gif) |
Barbara Boehmer
Messages: 9090 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
Maaher wrote on Tue, 27 March 2007 01:13 | I just saw Barabara's reply here. Does OraFAQ accept non-Oracle questions?
MHE
|
I didn't realize there was any doubt in any doubt in anyone's mind on this subject. I thought we were all already on the same page. In the past, everyone has banned non-Oracle questions related to MySQL and SQL Server and MS-Access, as do all other Oracle forums that I know of. The standard response is usually to point out that, although there are ANSI SQL standards, the SQL is still very different and questions about other databases should be posted on their forums, not ours. I expect that forums for other databases would respond similarly if we posted Oracle questions there. The only question in my mind is whether to just lock such topics or delete the entire thread. Responding to such things sets a bad precedent. However, with newbies, it can sometimes be appropriate to get clarification as they may not know what database they have and may be referring to something by the wrong name. Also, there are exceptions where somebody needs to connect one database to the other or convert code that runs on another database to run on Oracle. In short, if it is related to Oracle, allow it, but if it is a purely SQL question for a non-Oracle database, then do not allow it.
I locked the recent non-Oracle post, explaining why, then received an email, requesting that I unlock it, responded repeating that I would not and why, then received another email from the user threatening to email everybody if I do not unlock it. I think it is time for Frank Naude to step in and ban this user before he can do that. Here is a copy of the latest email:
From : Saurabh Saxena <saurabh_12_23@rediffmail.com>
Reply-To : "Saurabh Saxena" <saurabh_12_23@rediffmail.com>
Sent : Tuesday, March 27, 2007 9:54 AM
To : "Barbara Boehmer" <baboehme@hotmail.com>
Subject : Re: RE: Unlock the topic
Go to previous message | Go to next message | Delete | Inbox
Hey,
I got only half answer and there are people willing to answer my NON-ORACLE question. How is it possible I am half...
Your duty is to protect your forum from harm contents, not to belive in lock/unlock; other wise I have to e-mail personally to each in the forum.
Thank you
Saurabh
On Mon, 26 Mar 2007 Barbara Boehmer wrote :
>No, I will not unlock it. The OraFAQ forums are for Oracle questions only, not MS-Access questions. Non-Oracle questions are not allowed.
>
>
>
> From: saurabh_12_23@rediffmail.com
>Reply-To: saurabh_12_23@rediffmail.com
>To: baboehme@hotmail.com
>Subject: Unlock the topic
>Date: 26 Mar 2007 04:11:09 -0500
>
>Hi,
>
>Please unlock the topic "How to get either of two records?" (Id #225100)
>
>I am waiting to get some response for my question.
>
>Thank you
>Saurabh
>
[Updated on: Tue, 27 March 2007 10:18] Report message to a moderator
|
|
|
|
Re: New sticky in the Newbie board! [message #227353 is a reply to message #227251] |
Wed, 28 March 2007 01:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/43055.jpg) |
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
I never really thought about it, actually. But I've modified the 3 stickies in the SQL & PL/SQL fora to offer alternatives for the non-Oracle people.
After a good night and a cup of coffee I come to this conclusion.
You're right Barbara, we need to stand our ground: Not Oracle? Delete the thread, with a note to the OP that there are alternatives on the net, like MSDN. Locking will, indeed, set a precedent.
MHE
[Updated on: Thu, 29 March 2007 05:30] Report message to a moderator
|
|
|
Re: New sticky in the Newbie board! [message #227378 is a reply to message #227353] |
Wed, 28 March 2007 02:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Maybe it would be convenient to agree on more things amongst moderators, especially when there are more and more moderators.
Things like what should be in Newbies and what can stay in Expert (or, maybe, remove the difference altogether), what to do with questions that are clearly answered in the FAQ? Lock those?
Lock questions from people that seem to be too lazy to try things themselves? (since there always seems to be someone ending up spoonfeeding them)
Etcetera..
|
|
|
|
|
Re: New sticky in the Newbie board! [message #227554 is a reply to message #227378] |
Wed, 28 March 2007 11:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/43710.gif) |
Barbara Boehmer
Messages: 9090 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
Frank wrote on Wed, 28 March 2007 00:10 | Maybe it would be convenient to agree on more things amongst moderators, especially when there are more and more moderators.
Things like what should be in Newbies and what can stay in Expert (or, maybe, remove the difference altogether), what to do with questions that are clearly answered in the FAQ? Lock those?
Lock questions from people that seem to be too lazy to try things themselves? (since there always seems to be someone ending up spoonfeeding them)
Etcetera..
|
On one hand, it would be nice to have a general set of guidelines. On the other hand, it is good to allow moderators to use their own judgment for each individual situation. Some things can be decided with a simple yes or no, such as whether to allow non-Oracle questions. But, other things are much more subjective, such as what constitutes a newbie question. The OTN forums have just a SQL and PL/SQL forum. They don't separate SQL from PL/SQL or separate newbies from expert. That eliminates the problem. However, there may be a lot of readers who don't want to have to sift through the newbie stuff to read the latest expert questions and may appreciate the separation.
I once was a moderator/administrator on a non-computer board where no individual moderator was allowed to take any immediate independent action on their own. Every little thing, every problem with any user, required a week of discussion, followed by a 24-hour voting period, and by that time what started out as a minor issue had turned into a major problem. I was their computer guru and dealt mostly with setting up what the site owner wanted, not with the actual forum content. They have since revised their ways slightly. I think it is important to avoid a situation like that, by allowing moderators to take immediate independent action. There were a few valuable features that I set up for them on that board. I created a hidden forum that only the moderators could see, in order to discuss certain problems amongst ourselves. I also created a hidden forum for "posts pending deletion" that automatically deleted anything moved to it after a specified time period. Anything that a moderator wanted to delete, was moved to that forum, where it was automatically deleted after 30 days. If another moderator wanted to see what was deleted, they could then do so. If there were objections and somebody wanted it partially restored, it could be done. If a moderator deleted a thread, then requested that the user be banned, the thread was still available for the site owner to see why.
I think it is important that we allow for individual moderator decisions and support each other's decisions, especially in the gray areas.
|
|
|
|
|
Re: New sticky in the Newbie board! [message #227688 is a reply to message #227632] |
Thu, 29 March 2007 01:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Barbara, I totally agree with you that moderators should use their own judgment above all. I don't see the point in having moderators if they don't have the possibility to act immediately.
What I meant was mainly what you called 'a general set of guidelines'.
I also like the idea of being able to discuss ad hoc 'in private' how to deal with a particular issue. Now, when in doubt, I PM Frank Naude, which in turn works well too. He always reacts promptly, including his advise on how to deal with similar situations in the future.
|
|
|
|
|
|
|
|
|
|
|