Skip to main content
  • EN

Hello

i am reading many tables from oracle non spatial

tables name

Table_A

Table_B

Table_C

i have around 30 table

and I would like to get the Output from all tables when Id= 45

i am not sure ,how to write the condition in where clause to test it in all tables

and In case it did not find the id in any table so I will not get any output from this table .

But in case also ,no id as attribute name in any table so I get nothing better than error ,if it is possible .

Fme 2021

 

Not having Oracle DB here so I can't test it, but I assume you can simply use the Where clause and enter something like

objectid = 5250

 For the FeatureReader the Where clause will work on all selected tables.

Not having Oracle DB here so I can't test it, but I assume you can simply use the Where clause and enter something like

objectid = 5250

 For the FeatureReader the Where clause will work on all selected tables.

Thanks 

objectid = ‘5250‘

it works 

Reply


Community Stats

30,122
Posts
114,332
Replies
37,750
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.