Posts by Paulo Gonçalves • 51 points
8 posts
-
1
votes2
answers874
viewsA: Java: create Inner Join using criteria
Following the Oracle documentation Would look like this: CriteriaQuery<Translation> translationQuery = builder.createQuery(Translation.class); Metamodel m = em.getMetamodel();…
-
-1
votes1
answer488
viewsA: How to change the order of the parameters in Oracle SQL Developer
Hello, Gabriel. You can use "Invisible Columns and Column Ordering" to solve your case. In the Oracle 12c version, to rearrange the columns logically, you can use "VISIBLE". Example: Create the…
-
2
votes2
answers120
viewsQ: Oracle SQL - Return of the first record between two dates
I have this query: SELECT codigo_usuario, dataproducao FROM tbproducao WHERE dataproducao >= to_date('01/02/2013', 'DD/MM/YYYY') and dataproducao <= to_date('30/03/2013', 'DD/MM/YYYY') and Is…
-
0
votes1
answer64
viewsA: What to do to save registry in my mysql database
Good afternoon, I see in your Sert, your columns id, Team Name 1, Team Name 2 etc... have spaces. Confirm in your table the names of the columns. Another thing, you’re getting…
-
0
votes2
answers1212
viewsA: Add sold quantity of all SQL products
In my understanding, it would change the order of "from" and "Inner Join". SELECT * P.ID, SUM(PO.QUANTIDADDE) as QUANT FROM PRODUTOS P INNER JOIN PEDIDO_PRODUTO PO ON PO.ID = P.ID_PRODUTO GROUP BY…
-
1
votes1
answer168
viewsA: make a search between two data php html mysql
Renan, good morning. Looking at your ajax, I noticed that your ajax does not send the "date" to your file "query.php", which is receiving the parameters via $_POST. Missing line: data: { dataInicio:…
-
0
votes0
answers243
viewsQ: What are the return values of compareTo in Java?
What is the difference between the 0, 1 and -1 returns of compareTo() in Java? Example: Date date1 = '08/02/2019'; Date date2 = '08/03/2019'; date1.compareTo(date2);…
javaasked Paulo Gonçalves 51 -
1
votes3
answers254
viewsA: How to concatenate a varchar into a Mysql function?
You can use the Concat both in a SELECT and within a FUNCTION. Using in the SELECT: SELECT CONCAT(coluna_1, " STRING ", coluna_2) AS STRING_CONCATENADA FROM SUA_TABELA Code on Github for future…
mysqlanswered Paulo Gonçalves 51