Questions tagged as 'sqldeveloper'

Tagged questions
1
answer

Error bd Oracle and C # [closed]

When trying to connect an Oracle database to Visual Studio 2015 I get the following error:    BadImageFormatException. This will occur when running in 64 bit mode   with the 32 bit Oracle client components installed. check the versions bu...
asked by 01.06.2017 / 04:14
0
answers

I / O error: The Network Adapter could not establish the connection

I have already restarted services I have seen that they are correctly in the listener.ora but it still marks me as if it does not detect it. This keeps coming to me    An error occurred while performing the requested operation:   ...
asked by 11.06.2018 / 18:50
0
answers

Error connecting to a new connection

The window stays there and does not make the connection It appears trying connection and does not connect.     
asked by 24.05.2018 / 22:04
2
answers

Create a view in sql that collects employee and salary data

I am doing a job for the school, in which they ask me to make a view that collects the following data: ID of the employee, name and surname, salary, maximum salary and% of the current salary with respect to the maximum (I do not understand th...
asked by 15.10.2017 / 11:37
1
answer

Error java.sql.sqlexception no suitable driver found for jdbc sqldeveloper

Could you help me with this error? I have a database in sql developer, I have created it with a table that includes users and passwords. Create a program with a login, I have programmed the button, I have created my connection class and...
asked by 22.08.2017 / 02:32
1
answer

sqlDeveloper can not find Java Runtime Environment

I have a problem with the DB client, sqlDeveloper and what happens is that it generates an execution error: I hope and you can help me, the environment variables are already configured that previously install! and I kept generating that er...
asked by 20.06.2017 / 18:28
0
answers

PROCEDURE SQL Server WITH PARAMETERS TO XML ERROR PLS-00049

I have a package with a store procedure that receives three parameters and makes a query of a user, that extraction I need to pass it to an xml file, but when I pass the parameters it marks me an error of "bad bind variable", if I put a fixed va...
asked by 15.06.2017 / 00:37
2
answers

Problem with the Group by help?

SELECT VENDEDOR.ID_VENDEDOR, CASE WHEN TO_CHAR(BOLETA.FECHA_BOLETA,'MM/YYYY')='05/2014' THEN SUM(COMISION_VENTAS.VALOR_COMISION_BOLETA) ELSE 0 END "COMISION" FROM VENDEDOR JOIN BOLETA ON BOLETA.ID_VENDEDOR=VENDEDOR.ID_VENDEDOR JOIN COMISI...
asked by 25.06.2017 / 04:14
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