Questions tagged as 'oracle11g'

0
answers

Doubt Query Line - Oracle

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...
asked by 27.12.2018 / 19:12
0
answers

Problem in code - SQL Developer

The following tables have an error: CREATE TABLE REQ_ROB_EQP ( REQ_PER_ROB_ID NUMBER, REQ_EQU_NOME VARCHAR(100), CONSTRAINT REQ_ID_NOME_PK PRIMARY KEY (REQ_PER_ROB_ID, REQ_EQU_NOME) --CONSTRAINT REQ_PER_ROB_ID_FK FOREIGN K...
asked by 03.12.2018 / 11:34
0
answers

DATA_FIM - DATA_ENTRADA

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),...
asked by 23.10.2018 / 20:48
1
answer

Power BI - Oracle SQL Query

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...
asked by 05.08.2018 / 20:22
0
answers

Error executing a trigger ORA-04092: Unable to trigger

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"...
asked by 20.07.2018 / 16:29
0
answers

Error in SQL Server Data Migration to Oracle

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...
asked by 21.06.2018 / 19:33
0
answers

Oracle 11G XE change size tablespace system

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...
asked by 14.06.2018 / 22:12
2
answers

How to use @MappedSuperclass @Id with @Sequence Individual - hibernate oracle

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...
asked by 29.05.2018 / 19:56
0
answers

Oracle Package SMTP, validate domain

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...
asked by 11.05.2018 / 20:49
1
answer

Hibernate + JPA 5 - Java Web

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 @...
asked by 09.04.2018 / 16:57