Most voted "oracle18c" questions
3 questions
Sort by count of
-
1
votes0
answers179
viewsWhat are Oracle queues (Queue)
I was working on an Oracle database import, and during the import noticed the existence of objects of type queue, I’m used to procedures,functions,view, etc. The one in question had never seen. I’d…
-
0
votes1
answer22
viewsAutomation of code
Using a DB2 database I need to automate a query and currently have the following scenario: SELECT * FROM tabela WHERE DATA1 < '2020-06-01' AND DATA2 >= '2020-05-01' How to make date conditions…
-
0
votes2
answers67
viewsHow to calculate the value of two subquery in Oracle SQL
How to calculate two subquery on Oracle? Could you explain to me how I sum up VALOR_1 + VALOR_2? SELECT COL1 , (SELECT SUM(TAB1.VLRTOTAL) FROM TABELA TAB1 WHERE TAB1.ID = TAB3.ID) AS VALOR_1 ,…