Posts by Samuel Oliveira Chaves • 63 points
8 posts
-
0
votes0
answers134
viewsQ: Using modules and their library dependencies at angular 9
I’m creating a library with angular 9 to be used in several projects and would like to know if it is possible to use dependencies within a module without having to import them in the main…
-
0
votes1
answer481
viewsQ: Mock local variable inside method with mockite and spring boot
I’m trying to simulate the return of a method on a local variable, but it’s always null, showing java.lang.Nullpointerexception I have the following code within a @service: @Service…
-
1
votes1
answer216
viewsQ: Jpa does not create column @lob
I’m mapping a field @lob to save image to a table, but jpa creates the table, but does not create the column. I created the column manually in MYSQL, but then the bytes do not persist either. My…
-
1
votes3
answers5145
viewsA: Pick number after comma
If you want to take the decimal part, do this: SELECT 7.89111 - TRUNC(7.89111) from dual; Result:0,89111 If you only want to get the numbers after the comma: select REPLACE((7.89111 -…
-
1
votes1
answer65
viewsA: SQL in propagated data
Have you tried that? SELECT PRODUTO.NOME, PRODUTO.QTDE, TABELAAUX.CODIGO, TABELAAUX.NOME_MATRIZ, TABELAAUX.NOME_FILIAL FROM PRODUTO LEFT JOIN ( SELECT MATRIZ.CODIGO AS CODMATRIZ, MATRIZ.NOME AS…
-
1
votes4
answers6983
viewsA: Delete thousands of records from a table
The Aron Linhares solution works well, it would only add the use of BULK COLLECT to improve performance. DECLARE CURSOR C_CURSOR IS SELECT P.ROWID AS CHAVE FROM PESSOA P WHERE P.IDADE > 40; TYPE…
-
1
votes2
answers246
viewsA: DATES applied SQL Decode function
The Motta solution works perfectly, but you can also use the NVL2 function. The code becomes more readable. NVL2( string1, value_if_not_null, value_if_null ) See the link:…
-
1
votes0
answers33
viewsQ: Aurelia - error executing the npm run build:Prod command
I’m learning the Aurelia (front-end framework) and downloaded a demo project (Aurelia_full_esnext_webpack) of the site http://coreui.io/. I am running the npm run build:Prod command, but it displays…
front-endasked Samuel Oliveira Chaves 63