Posts by Elisiany Oliveira • 136 points
7 posts
-
1
votes1
answer161
viewsA: Column splitting error with SQL Subquery
I did not understand what you wanted in the query, is to calculate the percentage of neighborhoods by city, or the total percentage of the table? I also noticed that the logic of your query is…
-
1
votes1
answer272
viewsA: several tables in PL/SQL on Cursor
Based on the little information passed, I believe that your query is already correct, the suggestion would be to put an UPPER in the STUDENT clause.NAME because you are passing the string 'RITA' but…
pl-sqlanswered Elisiany Oliveira 136 -
3
votes1
answer58
viewsA: Postgresql build error - Error
Ta missing to put the multiplications inside the parentheses (ex: SCO.MATH 2) . Another thing is that in alias can not put simple quotes ( '' ), causes error. The query would be: SELECT CAN.NAME AS…
-
2
votes2
answers485
viewsA: INSERT INTO with Mysql filter
The solution would be to make a subquery, as below: I created the PESSOA_2 table, which I want to insert data into it according to the PERSON table: In this case, the query to insert in PESSOA_2…
-
1
votes2
answers1208
viewsA: select month and year of a datetime field
You can use the TO_CHAR in the date field, passing the format only to return the month and year, as an example below: DECLARE data_exemplo DATE := TO_DATE('10/01/2005','DD/MM/YYYY'); data_exemplo_2…
-
1
votes2
answers1870
viewsA: Dialog does not open
Hello! Taking a quick look I noticed some details that you missed out on. First of all know that all the action components of the primefaces (commandXXX) by default already make requests via ajax.…
primefacesanswered Elisiany Oliveira 136 -
3
votes1
answer464
viewsA: Error when using required inputs in Primefaces
It seems to me that you’re just having a CSS problem. If you don’t want to create an external CSS file, you can do this within your own page: <style> .input-color{ color: #000000 !important; }…