Questions tagged as 'oracle'

Tagged questions
2
answers

order by in oracle subquerys

RESOLVED I decided to create a view equal to my work order table plus it was ordered by the team and the priority, and I kept the above query by changing only the table of the subquery that I placed the view I created, so I do not have to wor...
asked by 23.08.2017 / 15:04
3
answers

Select that respects all values in a list

I need to mount a very simple select, but I'm having trouble. SELECT SEQPRODUTO FROM MRL_PRODUTOEMPRESA WHERE STATUSCOMPRA = 'I' AND NROEMPRESA IN (1,2,3,4,5,6,7,8,9,11,13,14) I need to select the products where STATUSCOMPRA = 'I'...
asked by 15.08.2017 / 21:43
1
answer

Update notify change

Can you tell if a value has changed in an in-app table? Type I gave one UPDATE tabela SET valor = 1 WHERE id = 2; And in the application the message appears: O Valor foi alterado para 1 What I would like to do is to notify the clien...
asked by 30.06.2017 / 19:00
1
answer

SQLException: ORA-00257: archiver error. Until only freed

Have an Oracle database connection that makes a simple insertion into the database. The process was working, but you are now experiencing the error below. 2017-07-13 14:25:55.929 ERROR 12062 --- [nerContainer-21] c.z.h.p.HikariPool...
asked by 13.07.2017 / 20:18
0
answers

java.sql.SQLException: ORA-01000: maximum open cursors exceeded

I have the following error:    java.sql.SQLException: ORA-01000: maximum open cursors exceeded From what I researched, the error happens when the maximum number of cursors is exceeded, and to solve, or you increase the number of cursors o...
asked by 17.06.2017 / 00:56
0
answers

How to send the result of a query via email

I wondered if anyone would know how to do this to run the query correctly. I need this to be sent to the email appearing the result that in the case would be Name: Ariel [select rtstr1 as hostname from poldat_view where poldat_view.polcod...
asked by 07.06.2017 / 18:22
0
answers

Oracle database physical file

I'm having the same problem with this question: Where SQL Developer saves the DB file? but since I do not have points to comment on, and ask for it myself, start a new "topic". I've tried to do it the way the answer says, however, since I'm...
asked by 18.04.2017 / 18:18
2
answers

Oracle order by

Good afternoon guys trying to run the command below by sorting it down it displays the following error missing expression SELECT * FROM tab_style WHERE nm_uf like '% MG%' and like '% BA%' order by desc; Missing expression     
asked by 09.04.2017 / 20:02
1
answer

Select with re occurrences of a period record

I need to know if a record has occurred again in a 7-day period. For this, I have a table that saves the records and the date of occurrence. For example: Registro: x | Data: 13/03/2017 Registro: y | Data: 14/03/2017 Registro: x | Data: 17/03/2...
asked by 04.05.2017 / 16:14
0
answers

How to do linked server with Oracle database for SQL Server 2008 (and considering VPN connection)?

I need to create a Linked Server connection to my client's SQL Server 2008 database. This Linked Server will be with an Oracle database. My SQL Server 2008 database is on a client-side server. The Oracle database is located on another remote...
asked by 27.03.2017 / 15:02