Most voted "oracle18c" questions

• 1

  votes

  0

  answers

  179

  views

  What 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…

  oracle queue oracle18c

  asked 5 years, 4 months ago David 4,330

• 0

  votes

  1

  answer

  22

  views

  Automation 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…

  sql database db2 oracle18c

  asked 4 years, 6 months ago Rodrigo Sousa 11

• 0

  votes

  2

  answers

  67

  views

  How 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 ,…

  sql oracle oracle11g oracle12c oracle18c

  asked 3 years, 12 months ago Rafael Bernini 3