Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select whole "Objects"
jlaffer schrieb:
> o) Table COMPANY with the column ID
> o) Table EMPLOYEE, containing the column COMPANY_ID and for example the
> column EMPLOYEE_NAME.
[...]
> To get the desired result, UNION, MINUS and INTERSECT operations have
> to be performed.
> For each filter-criteria the user defines, the whole subselect has to
> be inserted into the SQL-Statement. As the user also has the
> possibility to use brackets "(" and operators like 'OR' to connect two
> filter conditions, the statement gets very big and complex.
But you create them automatically, so what's the problem?
Your database will be happy to execute slightly less boring
queries for a change.
Lots of Greetings!
Volker
Received on Tue Feb 14 2006 - 08:56:17 CST