Questions tagged as 'oracle'

Tagged questions
1
answer

Help in SQL query ORACLE

Dependency column: T - Holder; And wife; F - Children; FA - Adoptive Son As per table above, how do I bring data only from ZIP codes that differ from Zip Code:    Owner Admilson has 2 children with a different cp, as well as   holder...
asked by 13.06.2017 / 22:47
2
answers

Query to return specific values

In my table IDENTIFICACAO_PESSOA I have a column named IDENTIFICADOR . This column receives CPF values. However there are values there that do not correspond to CPF, that is, they are outside the standards of a CPF (999.999.999-99)....
asked by 02.03.2017 / 21:10
2
answers

Oracle Insert multi-line

I need to insert multiple records into a table where only one of them will change, the others are constant. For example: Insert into processo (ID, status, descricao) values (1, 'X01', 'lorem ipsum dolor') I have to make hundreds of inser...
asked by 17.03.2016 / 17:54
3
answers

Select Oracle returning many times the same result

My select works and returns the data I need, but it is returning more than 6000 times the same result. How do I return the result in only 01 line. NOTE: There is only one result for this code sq_transação , there is no possibility of...
asked by 05.01.2016 / 22:38
2
answers

Undefined Index with Oracle connection

For some reason, my code is resulting in error    Notice: Undefined Index IRRAD when attempting to query the Oracle database. The PHP code I'm using: set_time_limit( 600 ); date_default_timezone_set('America/Sao_Paulo'); $query2 = '...
asked by 22.10.2015 / 03:27
1
answer

SQLException: IN or OUT parameter missing from index :: 10

First time I'm working with connections, we're doing a college job for a social network, now we're doing the insert method. My question, when I run the test class, does it return an error. What causes this error? Note: we can not use any k...
asked by 16.10.2015 / 13:41
1
answer

Select with exception of values (SQL / Oracle)

I need to improve this select that already exists here to perform a query where the ICCIDs started by 8995 are not returned, but I do not have much knowledge of the database. How can I change this select? I use SQLDEVELOPER, however the clien...
asked by 08.06.2015 / 17:06
1
answer

MER - Model entity and relationship

I would like to know if my SRM is correct and if it is possible to make a N: N relationship between animals and schedules. Specifications I've created for the system: Computerize the schedules of a bath and cough, involving customers, atte...
asked by 25.06.2015 / 16:55
2
answers

Arrays in the 'NOT IN' WHERE clause

DECLARE string_valor VARCHAR2(100); lista_array dbms_utility.lname_array; contador binary_integer; BEGIN SELECT t.campo_a INTO string_valor FROM tabela t WHERE t.campo_cod = 1; dbms_utility.comma_to_table ( list...
asked by 05.02.2015 / 14:13
1
answer

Help Dynamic Combo with javascript

I'm doing some tests with PHP + Oracle and I'm having a question. I made a combo, which takes data from Oracle, and controls a textfield. But now I need to update another textfield, but there is no way. Can someone help me?
asked by 11.11.2014 / 18:30