Re: SQL : In-line select statements

Thomas Kyte wrote:

> Whats the advantage? without it, I would have to create at least one 'real'
> view to do the above easily.....

..and that makes it MUCH easier to maintain when all of SQL required for a view is together in one place. Try tracking down an explaination of why that report is wrong when you have to find and explain three or four seperate queries. It is much easier to comprehend and follow when it is all together in one view. Also, when the whole 'question' is together in one view, it is easier to see and try out alternative solutions to the problem. Received on Tue Aug 10 1999 - 10:10:31 CDT