Posts by sniffer • 31 points
4 posts
-
2
votes1
answer284
viewsQ: Know which Procedure or session is leaving open cursors
I wonder if there is any way to find out which session or Procedure(s) are leaving cursors open on Oracle, sometimes (not always) error occurs: ORA-01000: Ximum open Cursors exceeded…
-
0
votes1
answer516
viewsQ: JOIN between tables with some (s) of them empty
Goodnight I have 6 tables (A,B,C,D,E,F) A tabela A sempre contém registros e tem uma chave primaria ID The other tables B,C,D,E and F are all daughters of table A and have a column FK_ID that…
-
0
votes0
answers27
viewsQ: How to Generate XML of two Note and Note Items Tables Hierarchically
Staff would like to create the XML of two tables Imagine an example below CREATE TABLE T_PARENT (ID NUMBER, TOTAL_VALUE NUMBER, LOCAL_OPERATION VARCHAR2(100), AGENT_OPERATOR VARCHAR2(50),…
-
1
votes0
answers27
viewsQ: Structure and materials on HDF5 files
I wonder if anyone knows about books and materials on HDF5, in addition to those present on the site itself.