I want to be able to create a conditional join between two tables - e.g.
(bit pseudo codeish!).........
from table1 t1
innner join (select case when t3.category = 'RM QUOTE then t3.assigned_dept
else t4.name end as phil
from table3 t3
inner join table4 t4 on t3.name = t4.name) test
on t1.name = test.phil
I know the above does not work - any ideas how to?
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…