var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Subselect in "from" part of query
I've discovered that you can place a subselect in the "from" part of a query in Oracle, and then join with it in the "where" part.
select p.name, o.status_name
from products p,
(select s.status_name, o.order_id,o.product_id
from order o , status s where o.status_id=s.status_id) orders
This is quite neat, you can get really elegant solutions to some of your queries this way.
Currently I'm in the process of tuning one of these queries, and was wondering if anybody knows how Óracle goes about executing them.
Does it create some kind of in-memeory table from the subselect, or is the sql simply rewritten, or something else?
I'm using version 8.1.6
This might point you in the right direction....