PL/SQL-JSON implements encoding and decoding JSON in a PL/SQL environment. Using the objects json_object and json_array allows to compose and parse JSON. A performance test is avilable in the ...
sql-convert-decode-to-case ================== Convert oracle style deocde statements to "simple form" case statements Useful for migrating from oracle to postgres. If you use enterprisedb decode ...
Friends,<BR><BR>I'm trying to write a select statement that ends like this:<BR><BR><pre class="ip_ubbcode_code_pre"><BR>and sc.customer_name in (DECODE(shipto,'0',sc ...