How not to ask 20 questions...
Yesterday I pointed to a thread on otn that was purportedly started by a really obnoxious question. While today I think it might have been a troll (since the query was in fact cut and pasted from an older thread), it is not out of the realm of possibility. It very easily could be "real". I see them all of the time.
These sorts of demands come in various shades of "over bearingness" - from the "almost ok, but a tad pushy" to "way over the top". The example yesterday was in the "way over the top" category - and they happen quite often. The example I bring to you today is in the middle somewhere. Polite almost - but very "entitled" feeling. I got home quite late last night from traveling and checked my email - the email at the bottom was delivered at 1:30am and was sent by someone whose questions I had answered on asktom earlier that day. I answered their multipart question (something I ask them not to do on the form they submit questions with - do not ask more than one question) using a "search" link on asktom (eg: I answered by providing a link that just searched asktom using their question terms as the input...). I also pointed out how "insufficiently framed" the other questions were and sort of guessed at their intent. I guess I over achieved because now, it was time to play 20 questions..... I answered their email with "hahahaha, a few questions - funny. Amazing".
I wonder how many of them have answers that could be found via search... They have pretty much all been asked and answered (a couple of times..)
Just for grins, I was almost tempted to answer with amusing (to me anyway) responses, like this one for #13:
13 - That is a feature planned for version 42 of Oracle. It will be part of the prescient option under design now. Using this new feature, you won't actually have to load any data into the database - it'll just know the answers to your questions.
I was too tired though :)
Here I've few more questions. Please send me the answers. Its quite
1.How do I return a result set in batches, e.g. get rows 1 - 10, then
11-20, then next 10 and so on ?
2.How do I report the top 10 product members of the sales team in each
3.How do I embed single-quote marks in an SQL statement
4. Oracle seems to be very slow reporting large execution plans through
explain plan. Is there any way to speed this up ?
5.What is the most efficient way to update one table with values from
another table ? (Update/Delete with subquery) (170K file)
6.How do I find my SID (session id) from SQL*Plus
7.In a 'start with / connect by' query, how do I get child rows under
each parent to come out in sorted order ?
8.What bitwise operations does Oracle support ?
9.How can I convert numbers from Hex to Decimal (or any other bases) ?
10.What's the quickest way of deleting all (or a large fraction of) the
data in a table ?
11.I am using to_char(num_col,'9999') to get a 4-character output, but
is keeps coming out one column too wide. What's wrong ?
12.How do you write a query that ignores the effects of upper and lower
13.Can I find out how many rows will be affected by an SQL statement
without actually running it ?
14.How can I select a random collection of rows from a table ?
15.How do I export a database table to a flat file ?
16.What is the best way to identify and eliminate duplicate rows in a
17.How can I find out how many rows were affected by an SQL statement
after I have executed it ?
18.Is it possible to write a trigger referencing more than one table - I
want a trigger to audit a master/detail pair.
19.Is it possible to easily convert existing SQL scripts into a format
that cannot be read or altered? This is to improve security on an
20.Is there a way to read the names of a set of files with a given
extension from a directory as if from a SQL cursor