I am trying to create all (non-spatial) layer in QGIS2.16.2 Which uses a "select / join query" on Oracle database as data source.
I can successfully verify my query by executing it in QGIS DB Manager but It seems not to be possible to "load it as New Layer". After pressing the button "load now" nothing happens.
After some experiments I came to the conclusion that QGIS DB Manager only accepts simple queries (no joins ect ..) and needs a unique key column and a geometry column to load ash layer.
Unfortunately I have "read-only" permissions on the Oracle database, so creating a new view in the database is not possible.
Querying the different Oracle tables locally, using virtual layers takes to long or even makes QGIS crash due to the large data sets.
Are there other options?