Questions tagged as 'oracle'

Tagged questions
1
answer

How to update the result field based on criteria?

I have the following table: CREATE TABLE ALUNO ( RA NUMBER(9), DISCIPLINA VARCHAR2(30), MEDIA NUMBER(3,1), CARGA_HORA NUMBER(2), FALTAS NUMBER(2), RESULTADO VARCHAR2(10) ); And the following data: INSERT INTO ALUNO VALUES (1,'...
asked by 12.11.2014 / 21:04
2
answers

How do I update multiple rows in a table after it has changed?

CREATE or REPLACE TRIGGER TG_ATUALIZA_BLOQUEIO AFTER UPDATE ON pcclient FOR EACH ROW begin if :NEW.BLOQUEIO = 'S' THEN UPDATE PCCLIENT SET BLOQUEIO='S' where codcliprinc=:OLD.CODCLIPRINC; END IF; end TG_ATUALIZA_BLOQUEIO; Explain...
asked by 16.06.2015 / 19:34
0
answers

What is DIANA?

I was faced with a database problem related to the size of an object, which returned the following error:    pls-00123 too large program (diana nodes) The problem I understand and I know what can be done, but I would like to understand a...
asked by 11.09.2018 / 19:11
1
answer

The 'OraOLEDB.Oracle' provider is not registered on the local machine

I have a problem that is limiting my work, this is the following, I created a WebService with a connection string for a database in oracle: OleDbConnection con = new OleDbConnection("Provider=OraOLEDB.Oracle.1;Persist Security Info=Fa...
asked by 27.06.2017 / 15:37
1
answer

What is the most efficient way to connect an Oracle DB to a MySQL DB [closed]

Having the following scenario: a simple telephony application "writes" to a Mysql BD and a BD Oracle needed from time to time to look for information in this BD MySql. Has anyone done this yet? What would be the best practice? ps Actua...
asked by 26.06.2015 / 18:29
2
answers

Join SQL tables

I'm having a small problem making a Join between two tables in SQL, I'd like to know if you can help me. There are 2 tables GTM_ITEM_CLASSIFICATION and ITEM_REFNUM , both refer to the ITEM table, but using different keys. For the first t...
asked by 03.07.2014 / 14:24
4
answers

How to copy column data from one table to another table

I have a table named UC which has an email column, and I have a table backup of it. I need to copy the data (emails) from the email column of the backup table to the email column of the uc table, however I do not k...
asked by 23.05.2014 / 18:28
2
answers

What is the difference between COALESCE and NVL?

In Oracle when we have a table that has two campuses A and B, and in selection ( select ) we want to show B when A is null we have two commands that present us with the solution: Coalesce Select COALESCE(A,B) Teste from TabelaTeste...
asked by 10.11.2017 / 18:11
2
answers

GROUP BY SQL error

I have the following exercise:    List department code and name, the earliest and oldest admission date of each   department, sort by department name.    I was able to do the following: select d.department_id, d.department_name, max(jh...
asked by 30.08.2017 / 20:15
2
answers

JPA, Oracle and Handling Exceptions

I'm using vraptor 4, JPA and Oracle. But when an exception occurs during persistence, the error code that Oracle generates is not coming along with Exeption. This is the Repository @Repository public class AuthUserRepository { publi...
asked by 19.05.2014 / 22:14