Questions tagged as 'sql'

Tagged questions
0
answers

Take out new field crossing with another table large query

I was trying to modify an existing query using oracle sql developer 18.0.3 I have a large query I enclose the query to make it clearer <entry key="descriptor.pers"> WITH t1 as (select t1ID, listagg(nvl(cod,'#'), ',...
asked by 21.12.2018 / 08:55
1
answer

Error must declare the scalar variable @ p3where, in JAVA, when trying to update data from the database using a button

Hello everyone I hope you can support me, I start in this JAVA and make connections with SQL and I am little by little with learning, I hope you can help me I explain I'm doing practice and I started with an agenda, which everything was worki...
asked by 21.12.2018 / 01:50
0
answers

Numerical format in SSRS

Hello Good morning to all (my keyboard is in English so I do not have to put the tildes sorry), I wanted to ask you a question about the SSRS report builder. Notice that I have these numbers: 652298433 422185043 But they have to look lik...
asked by 21.12.2018 / 15:00
1
answer

Help with trigger insert

I'm new to SQL and I want to make a page as a new user record, and that this information is stored in a table, (this part I already have) The problem is that when creating a new user, I have 2 tables, one of companies and another of users, then...
asked by 18.12.2018 / 18:29
0
answers

How to group ORACLE consultation?

I have the following query but the result that throws me is not the indicated SELECT R1.SUBMISSION_TIME, A.TOTAL_MT, B.TOTAL_EXITO_MT_VAS FROM VAS.SMS_DATA_SMC R1 INNER JOIN ( SELECT SUBMISSION_TIME, COUNT (SM_ID) AS TOTAL_MT FROM VAS....
asked by 17.12.2018 / 15:48
0
answers

Response without ModelSerializer in Django?

I need to send the list "search" by response, the problem is that I can not serialize it with the library "JSON" that brings django by default and send it by the URL to the Frontend, how can I serialize the list and send it as any object json to...
asked by 21.12.2018 / 17:26
1
answer

how to find dates in java in a db with jdatachooser

I want to store data in a db but I get an error @Override public List<Ausentismo> list05(Date fechai, Date fechaf, Date fechaMesA, Date fechaMesS) { List<Ausentismo> list05 = null; String sql = "SELECT AU.COD_MOTIVO, AU...
asked by 13.12.2018 / 17:08
1
answer

INSERTING A SQL SERVER DATA BASE WITH PHP

Hi, I'm trying to make an insert to a sql server database with php. I execute the program and I get the message that it was inserted correctly but when I go to look in the database it does not insert anything and I can not find the error. This i...
asked by 11.12.2018 / 20:49
0
answers

Android Studio - Save records of a table in an Array

For my project I have a database in which I insert 10 records to the "books" table (it has 9 fields). These 10 records I need to save them in an Array [i] and then do something with the information. For example, in Array [0] you have to bring me...
asked by 11.12.2018 / 07:02
0
answers

FORMAT function used for numerical data does not work in sqlserver before 2012, alternatives

I'm using the format function to format a number, example: select format(45.123,'###############.00') print 45.12 select format(45.123,'###############.0') print 45.1 There is some way to do this in the previous versions of sq...
asked by 04.01.2019 / 21:33