Jdbc streaming for mysql and oracle


#1

In jdbc streaming for mysql, it is possible.

statement => "SELECT * FROM (SELECT A.CID, ROW_NUMBER() OVER (ORDER BY 1) AS NUM FROM TB_REN016_002 A WHERE LORA_DEVID= :LoraID AND PORT= :port AND MEAIN_STAT_CODE_NO != 7005) WHERE NUM <= 1;"

Like this : LORA_DEVID = :LoraID

But, in oracle, it's impossible??


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.