Posts by Marcos • 51 points
5 posts
-
0
votes2
answers670
viewsA: Arrays in the clause 'NOT IN' WHERE
Searching the old google and gathering information, I managed to solve the problem, I will leave posted here the result in case someone needs. DECLARE V_varchar2 VARCHAR2(100); l_List_char…
-
0
votes2
answers670
viewsQ: Arrays in the clause 'NOT IN' WHERE
DECLARE string_valor VARCHAR2(100); lista_array dbms_utility.lname_array; contador binary_integer; BEGIN SELECT t.campo_a INTO string_valor FROM tabela t WHERE t.campo_cod = 1;…
-
1
votes1
answer91
viewsA: Bitand in the Where clause
The solution was thus: SELECT z.campo_X, z.campo_Y, h.campo_H FROM tabela_Z z LEFT OUTER JOIN tabela_H h ON z.campo_Z_COD = h.campo_H_COD WHERE( ( BITAND(1, 1) > 0 AND z.campo_A NOT IN (2,4,8,9)…
-
1
votes1
answer91
viewsQ: Bitand in the Where clause
I need to do the following Query, but it is generating some syntax or logic errors. SELECT campo_X, campo_Y FROM tabela_Z WHERE( ( BITAND(1, 1) > 0 AND campo_A NOT IN (2,4,8,9) ) OR ( BITAND(2,…
-
3
votes2
answers2775
viewsQ: How to send and receive a file via Socket?
I am needing to send files via Socket on C++ Linux, as the file may have an extensive content it will need to be sent in pieces. In this case, I need to create a kind of protocol to send a file (in…