Questions tagged as 'oracle'

Tagged questions
1
answer

Error activating Oracle Flashback

I am trying to enable Oracle Flashback in an Oracle 10g database that I have mounted on a virtual machine (which has Windows XP). This is my script: --chechar si estan habilitados los respaldos flashback SELECT FLASHBACK_ON FROM V$DA...
asked by 13.07.2017 / 18:43
0
answers

How to use an Oracle function from PHP?

Cordial Greeting. I am working on Oracle 11G from PHP and it is necessary to use some functions of ORACLE from PHP and since I am passing more than 1 query at the same time to use INSERT ALL I am sending the data in an array and using the fun...
asked by 11.07.2017 / 23:02
0
answers

How to execute a procedure in a View? SQL Server 2012

In my Procedure a dynamic query is executed (use PIVOT ) where the last columns are dynamic, so when I want to create the view I have tried to use Openquery and OPENROWSET but always shows the same message.    You...
asked by 12.07.2017 / 01:14
2
answers

Error ORA-03134: Connections to this server version are no longer supported

In a web application I use 2 connections to 2 different servers of Oracle 10g, I use Visual Studio 2015 Professional, and I have installed Oracle ODAC 12 libraries in the development computer, I have referenced in the application said library...
asked by 29.06.2017 / 09:25
1
answer

Load the Jtextfield with a single Combobox

I have the following form and I need that when choosing the rut, dni from the combobox the data of said worker is loaded from the BD in the jtextfield (I am working from oracle express edition 11g) Any idea how to do it? would be a big help p...
asked by 26.06.2017 / 00:43
0
answers

PASS COLUMN CONSULTATION RESULTS

Good morning, I have the following query select e.documento,e.NOMBRE1||' '||TRIM(e.NOMBRE2)||' '||e.APELLIDO1||' '||e.APELLIDO2 "NOMBRE",l.concepto,l.valor FROM empleado e,vinculacion v,detallevinculacion vd,liquidacion l WHERE e.CODEMP...
asked by 21.06.2017 / 18:39
1
answer

Help with Error ORA-12547: TNS: lost contact

I come to present you an interesting topic to deal with you, it turns out that I installed Oracle Database 11g Release 2 in Ubuntu 14.04 that cost me a lot but apparently I did it. But I ran into a problem when I wanted to connect...
asked by 20.06.2017 / 22:20
1
answer

Query in tree with accounts by level

Good afternoon, I have a tabla that has clave , clave_padre , anio and nivel , and on the other hand I have a tabla2 that has the clave , cargo , abono , mes and anio . Wha...
asked by 14.06.2017 / 00:32
1
answer

Mother class of an outer join not visible (ORACLE)

Good morning, I have this select: select count(ob.obj_id) as appeareances, cl.id as classs, cl.intl_id as class_intl, cl.name as class_name, cf.name as classif_name, cf.intl_id as classif_intl, cf.id as classif...
asked by 21.06.2017 / 13:00
0
answers

code in sql does not meet the AND condition

where it is commented, prints me for example a date where in loan the day has a 06, but on the return date it does not have it and this record is being excluded, being that I put an AND so that when the return is different from 06 and the loan i...
asked by 03.09.2017 / 21:16