Deta_DataBase icon indicating copy to clipboard operation
Deta_DataBase copied to clipboard

make nest join table for plsql update

Open yaoguangluo opened this issue 6 years ago • 1 comments

tableName:test:update; culumnValuedate19850525; culumnValue:date1:19850526; condition:or:testCulumn1|<|20:testCulumn2|==|fire; condition:and:testCulumn1|>|100:testCulumn2|==|fire; tableName:utest:nest; condition:and:uCulumn3|<|20; relation:and:testCulumn1|==|uCulumn1:testCulumn2|!=|uCulumn2;

yaoguangluo avatar Jan 27 '19 17:01 yaoguangluo

baseName:backend; tableName:usr:update; condition:or:u_name|equal|123:u_name|equal|222; join:frontend:login; condition:and:usr_name|equal|123; relation:and:u_name|equal|usr_name; culumnValue:u_email:ok;

this plsql query is a really world sample. is working .thanks

yaoguangluo avatar Jan 27 '19 20:01 yaoguangluo