In 2010, someone asked an interesting question here on the toolbox. Basically, this was the Knapsack Problem. The MODEL clause demonstrated some real power compared to other SQL constructs. The problem was solved in two postings:

When I'm copying code from these pages, I use the following method:
1. Shrink the webpage in my brower (control-MINUS) until I can see the entire code box
2. Select the code
3. control-C to copy the code.
4. control-PLUS to enlarge the webpage.
5. paste (control-V) the code wherever I need it.
It's cumbersome, and perhaps there's a better way, but that's what I've used. "

Sorry! Something went wrong on our end. Please try again later.

Iudith Mentzel

September 19, 2017 05:04 PM

"Hello Mr.Ganote,
I am trying to follow-up after your exciting analyses on various tricky SQL topics,
and, of course, the MODEL clause is still one of them for most developers.
In this sense, your articles are extremely interesting, thanks a lot for your so very deep insights :) :)
There are relatively few places that really discuss this topic in a clear enough way
as to be comprehended also by mere mortals like us.
This is probably one of the reasons that it still remains mostly the realm of the
SQL gurus .

One issue that is very annoying, though.
The design of this website makes it extremly difficult to follow up after the articles published.
Those code boxes, whose content is ""jumping into a single line"" immediately when you put the cursor upon them, not to speak about their content being truncated if you try to print the page are simply awful, I cannot find any other more descriptive word !

As one who is regularly visiting Tom Kyte's wonderful AskTom site, I am sure that you
unerstand exactly what I am trying to say.
Asktom is really a model of how a web site can be top friendly while still remaining
a TEXT ONLY site, friendly for reading, printing, a.s.o., with useful information only
and without the hundreds of links that just disturb a reader's attention when he is really trying to make the best and deepen into a topic.

Maybe something can be done with this site also ?
I think that at least offering a ""Printer friendly"" version of a page, so that we could print only the content, including of course non-truncated code, without all the non-related stuff could be extremely useful and welcome. Many other sites do have this feature.

It's really a pity not to have this wonderful content conveniently available for as many developers as possible.