Posts by Isac Oliveira • 31 points
4 posts
-
0
votes0
answers66
viewsQ: Limitations in an SQL query
I have to make a report that shows the main customers of each seller (the top 10 customers who spent on each seller) I am using the Oracle database to make this query. Each seller has more than 40…
-
-1
votes1
answer862
viewsQ: Building select in HQL
I’m starting to use JPA with Hibernate and I’m having doubts about the HQL query, I did some research on the Query hql but I couldn’t understand much. I want to do this select in hql only I did not…
-
1
votes2
answers1727
viewsQ: Oracle-Variable without data
I have a problem and a doubt at the same time, I made a function to see invoiced orders and declared a function variable so: select filsaida into v_loja from mov_itped where pedido= p_pedido and…
-
0
votes2
answers5935
viewsQ: Is there any clause similar to LIMIT in PL/SQL
I am using PL/SQL and would like to know if you have any clause or sql script that is similar to sql LIMIT clause, I’ve been searching here and found rownum < = X , but does not meet what I want…