Questions tagged as 'sql'

Tagged questions
1
answer

Doubt about PL / SQL function

I wanted to know how to create a function that inserts data into a table. What value should I return ( return )? With a procedure I do it correctly, but when it comes to doing it with a function, I do not understand what value I should ret...
asked by 18.04.2017 / 19:56
1
answer

Problems in collecting data by select

I have a problem making a simple selection of a date. I commented: I want to collect the month of the creation of a file and that is ordered by the date with this sentence: select to_char(fecha,'MONTH') as MES from archivos order by (fecha...
asked by 26.01.2017 / 10:46
1
answer

Left Join in Oracle query

Good morning! I have the following query: SELECT * FROM (SELECT CLIENTE.CTE, CLIENTE.NO_EMPLEADO, CLIENTE.CTE_N, CLIENTE.NOMBRE, CLIENTE.AP_PATERNO, CLIENTE.AP_MATERN...
asked by 03.05.2017 / 16:14
1
answer

Do SELECT with 20 different Monsters IDs in SQL server 2008 R2

I have the following SQL server structure: ROW Monstruo MobID Fecha 1 Feo 4001 14-12-2016 22:22:03 2 Horrible 4002 12-12-2016 22:22:03 3 Espanto 4003 11-12-2016 22:22:03 4 Espanto 4003 17-12-2016 22:22:03 5...
asked by 30.12.2016 / 16:20
2
answers

PL / SQL: convert varchar to time to get difference later

I have saved in a table a varchar that represents a time, for example '23: 30 '. What I want to do is convert that value to time and then calculate the difference with respect to sysdate ... Will there be any way to do it? I con...
asked by 25.11.2016 / 05:59
1
answer

Activate a combobox depending on the result of another combobox

I want to upload the values in this combo box depending on the selection made in another combobox. I mean, I have an application that allows you to add a car and I would like to select the values through queries depending on the value taken...
asked by 22.12.2016 / 09:55
3
answers

I can not nest joins with SQL statements in Access 2013

I test this in Access 2013 and says there is an error, but it does not specify which one. SELECT DISTINCT factura.n_factura, factura.data, factura.import, factura.concepte, departament.nom, programa.nom, despesa.nom, emisor.nom, destinatari....
asked by 02.12.2016 / 19:52
1
answer

What is the SQL statement to insert data in my Database in MySQL in Java?

In my program using Java in Eclipse and MySQL, I have the following data: Call number (int): callcenter.getTotalCalls () Type of call (string): Local Source Number (string): txtOrderNumber.getText () Destination Number (string): txtDef...
asked by 22.11.2016 / 04:45
1
answer

INNER JOIN query on Android with SQL Server [closed]

I need to make a select query with two different databases. How could I? From the database Xtraining I have the table dbo.tbUsuarioOperario with the field idOperario . From the database Workflow I have the...
asked by 14.11.2016 / 15:58
1
answer

Problem with SQL query in Oracle [closed]

I have a system which performs the query of a product in a store. That is, in my interface I select todas and then I enter the product code and I should throw all the stores with that product available. The query I modified it for that pu...
asked by 14.11.2016 / 17:21