I need to do the following Query, but it is generating some syntax or logic errors.
SELECT campo_X, campo_Y
FROM tabela_Z
WHERE(
(
BITAND(1, 1) > 0 AND campo_A NOT IN (2,4,8,9)
)
OR
(...
When doing some queries on a view using JPA (2.1) with Hibernate , I'm having this warning . Although it's working and just being a warning , it bothers me a little.
WARN org.hibernate.loader.Loader - HHH000444: Encountered request for...
My database server has failed and I need to restore a dump from a database. But when I try to run the tool imp from Oracle 10g x and it returns me the error
1882 - região de fuso horário não encontrada
Follow the log of the tool imp
...
I've tried the code below but it did not work, I'm using Oracle 10g.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class AcessoBanco...
I would like to know if it is possible to create an agent / job in Oracle to query the data of a given table and insert the data of this table into another table that is in PostgreSQL.
Or you can get through the PostgreSQL PGAgent to create a...
.NET Dll is used to compile scripts, but in Oracle 10g databases the scripts are decompiled and you need to perform the compilation using a SQL Developer , for example.
Reported that this occurs only for Oracle 10g.
Why does this o...
I'm working with Oracle database and PHP, I need to return only one product each with the most recent change date, the tables are as follows.
product
price Ihavetriedseveralquerytypes,butIalwaysgetduplicateresults.Andtryingtogroupwiththef...
I am having problems when an application tries to connect to the database, I get the ORA-12154 TNS error: could not resolve the connect identifier specified.
When I tinker or try to connect via pl / sql developer by sql plus everything happen...
I need to create a procedure enviar_email_servidores that calls another pr_envia_email .
The procedure to be called ( pr_envia_email ) has the function of sending e-mail, and I need the message sent to this email to be the...