In the query below you are leaving this way.
Unidade Ordem_Compra CNPJ Aprovador
Sim Boavista 29021 155454878787 Ivan
Sim Boavista 29021 155454878787 Romel
The question is: How do I leave o...
I'm new to the PL / SQL world, could anyone help me with the code below?
SELECT ap.nr_atendimento,
ap.DT_ALTA,
ap.DT_ENTRADA,
(SELECT SUM (to_char(TRUNC((apu.dt_saida_unidade - apu.dt_entrada_unidade * 60) / 3600),...
Hello,
I'm trying to get data in Power BI via Query in an Oracle DB and is experiencing the following error.
Unable to establish connection Details: "Oracle: ORA-01843: not a valid month"
SELECT DISTINCT
J.JOBID,
J.JOBNAME,
--J.FOLDER...
I have the following problem:
- I can not execute a job (Scheduling) after an insert retrieved by the trigger.
Line 2: ORA-04092: Not possible on a trigger ORA-06512: in
"SYS.DBMS_ISCHED", line 135 ORA-06512: under "SYS.DBMS_SCHEDULER"...
I have a problem migrating the data that is in SQL Server to Oracle, using that "Migrate to Oracle" tool in SQL Developer, where it associates the data between the involved banks through a repository. >
Then in the execution the data migration...
I have following script
DECLARE
countTablespaceFile integer;
BEGIN
SELECT count(*)
INTO countTablespaceFile
FROM DBA_DATA_FILES
where file_name in ('/oracle/bdond/cbiep01/bdrgt/system01.dbf',
'/oracle/bdond/cbiep...
I need to solve a question of using inheritance and sequences with hibernate and Oracle.
I'm using Maven with:
hibernate-core 5.1.5.Final
hibernate-entitymanager 5.1.5.Final
hibernate-validator 5.1.3.Final
eclipselink 2.6.5
ojdbc6 11.2.0.4
ja...
I want to know how I can:
validate domain using Oracle Package SMTP;
Can I validate a domain or even an email without having to send a email ?
I want to use an action close to "ping" to answer the question.
Thank y...
I need help with the following problem.
When running my java web project in Glassfish the hibernate at every run try to recreate my tables.
Minha Entity.
@Entity
@Table(name = "Estados")
public class Estado implements Serializable {
@Id
@...