Posts by Andre Krepsky • 116 points
8 posts
-
1
votes1
answer261
viewsA: Mirroring of Database
The process of synchronizing data between different instances of DBMS can be done in several ways, but usually through a process known as replication. There are several products that provide a solid…
-
5
votes1
answer809
viewsA: Error message after opening Excel file generated by an application
The POI is divided into libraries H and X. Libraries H (HSSF, HWPF, HSLF) produce documents in format .doc, .xls and .ppt, as libraries X (XSSF, XWPF, XSLF) produce the formats .docx, .xlsx and…
-
0
votes1
answer322
viewsA: What is the most efficient way to connect an Oracle BD to a Mysql BD
The ideal solution depends on various questions, such as Oracle version, table size, query complexity, update frequency and developer’s technical capability. It is necessary to establish these…
-
1
votes2
answers295
viewsA: Report showing the Column Index
It was hard work, but it was fun :-) WITH raw_xml AS ( -- Obtem um flaten XML da tabela departments SELECT TRIM(COLUMN_VALUE) AS vals FROM TABLE(XMLSEQUENCE(CURSOR(SELECT * FROM departments))) ),…
-
2
votes1
answer455
viewsA: How to make a query with different table conditions
The modeling needs to improve even, but for what I saw code is primary and foreign key. Assuming this is true, then it is necessary to include the PERSON table in the query in order to search for a…
-
1
votes1
answer627
viewsA: Domain Modeling - Payment Methods
I wanted to comment instead of answering, but I still do not have enough points for such. Sorry. Looking from the point of view only of Object Orientation, the problem seems to me to be a simple…
-
0
votes2
answers455
viewsA: Questions about database and Android
It seems to me that in this case, there are only two entities involved: questions and answers. Whether the answer is correct or not is just an attribute of the answer. I will put a "generic" SQL…
-
0
votes1
answer75
viewsA: When should I create a Constraint like DEFERRED?
A good practice with DEFERRED finds application in the movement of large volumes of data. When the validation of the Constraint occurs only in COMMIT, usually the Chunk (very large volumes should be…