Questions tagged as 'oracle'

Tagged questions
1
answer

Change result SELECT by sequential

I have the following query: SELECT DISTINCT N.SNUMERO, I.SNOMBRE, S.SSERVICIO FROM PROC_CEDULA CD JOIN CAT_NUMINTERV N ON CD.NIDCATNUMINT=N.NIDNUMINT JOIN CAT_INTERVENCIONES I ON CD.NIDCATINTERVENCION=I.NIDINTERVENCION JOIN CAT_SERVICIOS S ON...
asked by 21.03.2018 / 20:45
1
answer

Use a case with data from a table and have the results of that case save them in a table

I have 1 table called 'CFACTURACOMISION' which has the columns. CLFILIAL, CLCLIENTE, CLASESOR, FOFACTURA, DACHAFACTURA, MNFACTURA, MNDESCUENTO MNIVA, MNTOTAL, FEVENCIMIENTO, CONDICIONESDEPAGO, PROMVENTA. The main objective of this table is...
asked by 20.03.2018 / 19:36
0
answers

Export array to csv or xls with php and oracle

I need to be able to export an array to csv, please, the code: <?php require_once ("./conexion/conexion.php"); if (!$conn){ $msg = "Cannot connect to Oracle ".oci_error(); } else { $msg = "Connected to Oracle"; } $sql = 'SELECT *...
asked by 13.03.2018 / 19:04
0
answers

DPI-1047: 64-bit Oracle Client library can not be loaded - Django & Windows Server 2012 R2

I am running a Django application in Windows Server R2 which makes connections to an Oracle Database, however when the queries are made from the page it shows me the following Error: DatabaseError Exception Value: DPI-1047: 64-bit Oracle...
asked by 29.03.2018 / 00:22
0
answers

I can not install oracledb on nodeJs 7 - w7 x64

I execute the command: npm install oracle/node-oracledb.git#v2.1.2 link: Official node-oracledb page And I receive the following messages: > [email protected] install C:\Users\sti\Documents\Softten\qusar-prueba-backup\node_modules\...
asked by 09.03.2018 / 19:36
0
answers

Update data in pivot table ADF

I have a Pivot Table ADF (work with JDeveloper 12c), where in the columns I have grades and rows, subjects. The idea is to select one of those notes and edit it in the same pivot table. The pivot table is like this: I hope the questions...
asked by 28.02.2018 / 12:59
0
answers

Problem with Oracle view queries

I'm having an error that I can not understand why it happens ... and therefore how to avoid it. I will try to explain it. I created an entitity, from an oracle view: @Entity @Table(name = "VER_CONSULTAS_HISTORICO", schema = "HISTORICOS") pu...
asked by 02.03.2018 / 14:29
0
answers

create new table from another one in the database in vb

I have created tables in my database, which are displayed in a datagridview individually, but by modifying one of them, I want to save as a new table within the database , thanks by adepntado     
asked by 23.02.2018 / 22:30
0
answers

Manipulate content of a cursor in Oracle

I have a stored procedure ( SP1 ) that returns a cursor with many columns, I need to know how from another stored procedure ( SP2 ) I call SP1 strong> and the result manipulated it with a SELECT to group, add and do other kinds of thing...
asked by 23.02.2018 / 17:30
0
answers

Get a single record, in Oracle 12c

SELECT * FROM ct_factura,ct_dosificacion,ct_contrato_cuenta WHERE ct_contrato_cuenta.n_id_factura = ct_factura.n_id and ct_dosificacion.n_id = ct_factura.n_id_dosificacion and ct_factura.n_id (5456,5470,5458,5459,5460,5461,5462,5463, 5464,5...
asked by 15.02.2018 / 16:42