26ai ADB
Example:
select "DATA",rawtohex("RESID"),"ETAG" from "SOME_USER"."SOME_JCV" where JSON_EXISTS("DATA",'$?( (@.asset_id.stringOnly() == $B0) && (@.type.stringOnly() == $B1) && (@.subtype.stringOnly() == $B2) )' passing :1 as "B0", :2 as "B1", :3 as "B2" type(strict));
Where:
SOME_JCV - JSON COLLECTION VIEW
Error:
SQL Error: ORA-03048: SQL reserved word 'SELECT' is not syntactically valid following '..., :3 as "B2" type(strict))
There is no error In SQL Developer Version 23.1.1.345 for this select