Questions tagged as 'oracle-sqldeveloper'

Tagged questions
1
answer

character set mismatch COALESCE

Hi, I have a problem with this query, it tells me the error ORA-00932: inconsistent datatypes: expected NCHAR got NUMBER 00932. 00000 - "inconsistent datatypes: expected %s got %s" *Cause: *Action: Error en la línea: 54, columna: 43 I...
asked by 03.09.2017 / 03:20
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
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

Move file from local to server by ssh or sftp

I use the spool to capture the result of a simple query and pass it to a TXT that I place on my local machine in C: \ TXT. But I need to deposit that file in a remote directory using ssh. How could it be done? I was researching to see if from...
asked by 11.12.2016 / 00:06
2
answers

Consult a segmented field

I have two tables which one is created from the data of the other fields: CREATE TABLE1( CAMPO1 VARCHAR2(15), CAMPO2 VARCHAR2(15), CAMPO3 VARCHAR2(5), CAMPO4 VARCHAR(20)); CREATE TABLE2( CAMPO1 VARCHAR(20), CAMPO2 VARCHAR(30)); I want to i...
asked by 22.11.2016 / 17:30
1
answer

Entity framework with oracle developer. Validate the user

// Button Event protected void LoginButton_Click1(object sender, EventArgs e) { bool existe; string query = "SELECT COUNT(*) FROM USUARIO WHERE login= :p_login AND password= :p_password "; cmd.Parameters.Add(":p_login", OracleTy...
asked by 24.07.2018 / 19:39
1
answer

Doubt in update in sql developer [closed]

Good afternoon, a doubt to make an update of a value in a table is necessary to do it through a query with the Update instruction or can it be done directly in the table as if it were an excel? Excuse my ignorance I'm new to this     
asked by 08.08.2017 / 18:54
1
answer

SQL query help [closed]

Hi, could you tell me if this exercise is done with a subquery? "Indicate the DNI, first and last name of the owner who has the Casa Particular with more m2." Thank you.     
asked by 04.01.2018 / 19:06