Posts by Eduardo Teixeira • 99 points
2 posts
-
0
votes1
answer106
viewsA: How to convert JSON to XML in ORACLE 11g?
Erick, have you tested the "pljson"? He does what you need, in this post recommended and suggested the following test script: declare v_json json := json('{ "EMPLOYEE":[…
-
-1
votes1
answer284
viewsA: Know which Procedure or session is leaving open cursors
As Anthony mentioned, you can make a query to identify (logged in as system): -- recuperar sessao para matar lock select sid ||','|| serial# sessao from v$session where sid in ( SELECT a.SESSION_ID…
oracleanswered Eduardo Teixeira 99