Questions tagged as 'oracle'

Tagged questions
0
answers

Search at Oracle Bank forfeiting session

Good day dear, I'm having serious issues with using the Oracle database and losing the session. The scenario is as follows: thousands of queries, some crash and when we will see if it is still running, they are no longer in the bank. This hap...
asked by 26.09.2016 / 14:30
1
answer

Check for UK before creating a

I have the following query: alter table FINALIDADE_OPERACAO_MODAL add constraint UK_t127pwh154arjh5whq0g4dlrm unique (NOME); As I create a function that checks if it exists before, and if it does not exist, it creates, and if it al...
asked by 26.09.2016 / 19:19
2
answers

No update of a PL / SQL collection

I'm trying to update a parameter in a table, based on previous values of a collection , it will update the id attribute of a given document table id. I also created an insert into a test table, which performs perfectly, all attributes. I do not...
asked by 10.10.2016 / 23:57
1
answer

Serializing a query result to JSON?

I'm adding the result of a query to an array and I'm trying to serialize to Json . I am not able to print my JSON correctly, could you help me? My code: <?php ini_set('max_execution_time', 123456); $conn = oci_connect('teste', 'teste1...
asked by 12.08.2016 / 21:07
1
answer

2 FK SELECT on the same table

Given this scenario: Imagine a scenario in the field of oceanography, where table_A, in addition to the primary key, also needs to keep the direction of the wind (wind direction) and the direction of the wave (dir_condulation). Knowing that t...
asked by 15.09.2016 / 12:07
1
answer

Select two time fields where one of them moves past midnight

I have two tables with the following schema: data | hora ini | hora fim -----------|------------|--------- 16/08/2016 | 1115 | 1319 16/08/2016 | 1320 | 1419 16/08/2016 | 1420 | 90 In the second table, it already ha...
asked by 17.08.2016 / 22:26
1
answer

Creating multiple dynamic rows in an oracle table

I need to create a new table with multiple lines using data from a previous table as a parameter. For example _______________________ | nome | quantidade | |--------|------------| | xyz | 2 | | abc | 1 | ----------...
asked by 11.08.2016 / 16:41
1
answer

Permission to access a PHP + AD + Oracle system

Good morning, I'm new to PHP and I'm starting a system for the company I work for, generating reports. Currently my PHP code authenticates with an Active Directory, and when connecting, it goes to a page with several reports. These repo...
asked by 19.07.2016 / 15:53
1
answer

How to import Dump with 2 schemas for different dataspaces

I have a Dump with which expdp was made with 2 schemas. I would like to impdp remap tablespace to 2 new tablespaces . My parfile current: userid=dba/dba@streetfight dumpfile=expdp-ryueken-15072016.dmp lo...
asked by 15.07.2016 / 14:18
0
answers

Oracle.DataAccess.Client.OracleConnection is not defined

I need help because I can not proceed because of the message    Oracle.DataAccess.Client.OracleConnection is not defined. How can I solve this problem? I'm using Visual Studio 2015.     
asked by 12.07.2016 / 16:05