Questions tagged as 'oracle'

Tagged questions
0
answers

change nls_date_format oracle

My oracle now has: NLS_DATE_FORMAT DD/MM/RR NLS_DATE_LANGUAGE SPANISH Then I execute: alter session set nls_date_format = 'DD-MON-RR'; alter session set NLS_DATE_LANGUAGE = 'AMERICAN'; And it changes it without problems, but when...
asked by 18.05.2017 / 17:27
1
answer

Update of a field with the result of a select that returns several PL SQL records

My query is as follows: I must make a query that adds the prices grouped by several concepts, then, insert those results in the totals column, only when the quantity is different from 0. It would be like this: Precio Departamento Uni...
asked by 19.05.2017 / 17:07
1
answer

error when consulting a table with name something $ something

I have a query similar to this: select * from nombre$tabla where valor = 1; If I run this on my bd engine it works (Oracle), but when I run this from PHP it does not return records, the code in php is sending it like this: $query = "selec...
asked by 17.05.2017 / 00:24
0
answers

Oracle error when consulting sdo_geometry coordinates

you will see, I am making a query to the database from my program made in c #, the query is the following one (an example that should be valid): (select ad.ordem_aa ordem_aa, mfx.sequencia seq, mfx.nrnac nacfx, ad.nomep as area, mfx.nrint...
asked by 08.05.2017 / 18:01
1
answer

discover loopback models js

I am trying to discover the models in an oracle database with loopback as the documentation says but I do not know how to generate the .json models, they know of some example, in the documentation it says that it should be used with fs.writeF...
asked by 29.04.2017 / 06:10
1
answer

Problems with PDO and PHP

I need to connect to a db oracle, for that I'm using the following code! <?php class ConnectionDBTOAD{ private static $conn=null; private static $server = "mi host"; private static $db_username = "mi usuario"; private static $db_password =...
asked by 27.04.2017 / 15:14
1
answer

plsql script does not return anything

I have a problem with this script since I have the database full but when executing the following the courses do not return anything DECLARE CURSOR VA_QUERY IS SELECT Business_Area_Cd , Business_Area_Name FROM EXMCPRA.BUSINESS_AREA;...
asked by 25.04.2017 / 16:25
0
answers

Error message by the variable type when CASE is applied in a field of a table (ORACLE)

I have part of a query for a data dictionary in Oracle: I am trying to change the value of the DATA_DEFAULT field in case it is null . When I make the query with the field that is commenting (blue arrow) I get the following...
asked by 22.03.2017 / 18:22
1
answer

Export dump data from Oracle to MySQL / PostgreSQL

I'm looking for the right way to export a Oracle g10 database from 16 gigas to MySQL and / or PostgreSQL em>. I say export because I want to have the new data dump formatted for MySQL / PostgreSQL and then do the migration. Mai...
asked by 11.03.2017 / 14:18
1
answer

Efficient way to move tuples from one table to another, discarding repetitions of a specific attribute

I have two tables, and I have to move data from one to the other. The first table stores, among other things, customer data. The second table is empty, it is where I want to insert the tuples. The first table has this form, I do not write it...
asked by 06.03.2017 / 17:43