one of the problems this particular forum seems to incur -- all the time --is that people post generic SQL questions here, and then get PL/SQL (Oracle) answers
or they post PL/SQL questions and get generic SQL answers
it's hard to fault them, either, since the name of the forum is SQL and PL/SQL
is that confusing, or what??!!
note that the description of this forum is
The Standard Query Language for virtually all relational database systems currently in use. Although most vendors slightly enhance their versions to take advantage of features specific to their own software.
i'm going to recommend to the moderator(s) of this forum that they change this forum to Standard SQL and put a sticky thread on it to direct people with PL/SQL questions to the Oracle forum
p.s. and perhaps another sticky that says "please don't post database-specific solutions, use standard SQL only"
I don't think that's absolutely necessary... however I would make a forum rule that you MUST post which specific db you use with each post. It's only common courtesy and of course in the best interest of the poster, assuming they want a prompt and correct answer.