Questions tagged as 'oracle'

Tagged questions
1
answer

How to make a change in "Cascade" using oracle

How can I change the ID of my table BANDAS_E_ARTISTAS and ensure that other foreign tables also change via PL / SQL? TABLE BANDAS_E_ARTISTAS ID NOME_ARTISTICO 01 RAÇA NEGRA 02 OS MENUDOS 03 KELLY KEY 04 LUIZ CARLOS --------------------------...
asked by 30.05.2017 / 14:58
2
answers

LISTAGG function returning repeated values

I have a multivalued field in which I need the result to return on a single line, so I'm trying to use LISTAGG, but it returns one value per line and each value repeated 5x. Any ideas? I'll paste the code to make it clearer. SELECT DIS...
asked by 08.06.2017 / 17:54
1
answer

Character Explosion in Oracle

I have the customer base, and the customer base: COD CLIENTE 128 JOAO 129 MARIA 130 DULCE NOTA 234.123.334.128.50 235.124.338.128.49 Note that the customer code is inserted in the note number, which in this...
asked by 12.05.2017 / 16:05
1
answer

Compare Oracle Data

I have the following column in oracle DATA_FILTRO 01/04/2017 10:27:15 I would like to compare the month and year: SELECT DATA_FILTRO FROM TABELA WHERE TO_CHAR(DATA_FILTRO,'MM/YYYY') ='04/2017' In PLSQL it works, however in PHP it give...
asked by 10.05.2017 / 19:42
1
answer

What is the "function" in Oracle equivalent to a set generator?

I'd like to know, which command in Oracle would be equivalent to SET GENERATOR GEN_ID_TABELA TO 5; (command made in FireBird ) Because I would like to create a script with the inserts , but in order to avoid any errors...
asked by 19.05.2017 / 19:15
1
answer

How to use iReport with Oracle?

I'm having trouble adding the Oracle driver to iReport Designer , I tried to follow some tutorials, but I was not successful. So my question is, how do I add and make the necessary settings for the Oracle driver? Note: Try following t...
asked by 18.04.2017 / 16:59
1
answer

Error ORA-01843 when importing table in Sqoop

I'm facing an error from which I can not understand the source. Previously I had imported a table with the same data format, with 54 million lines to the HDFS of my Hadoop cluster . Now I created a _View_ in my database Oracle an...
asked by 16.05.2017 / 22:23
2
answers

Search and persons having the same name, surname and date of birth [closed]

How can I make a select in Oracle that brings all people who have the same name, surname and date of birth but have different ID's.     
asked by 31.03.2017 / 15:58
1
answer

Where does SQL Developer save the DB file?

Where do the banks I create in SQL Developer get saved? I would like to be able to choose the location / folder to save the Bank, but I do not know where it is saving.     
asked by 27.03.2017 / 22:11
1
answer

Is it possible to use the same name of a column as a parameter name in a cursor?

I have the following cursor: -- CÓDIGO OMITIDO DECLARE CURSOR CUR_AULAS(IDTURMA NUMBER) IS SELECT ID, IDCLIENTE FROM AULAS WHERE ATIVO = 1 AND IDTURMA = IDTURMA; It will always return true as i...
asked by 24.03.2017 / 15:38