Questions tagged as 'sql'

Tagged questions
0
answers

WHERE failed to associate a column to query in a view

I'm passing some parameters to a view where I need to get the return of this query. When defining the filters in the Where of my query, the query return reports the following error:    Invalid 'competition' column name. I know it's my cod...
asked by 10.07.2018 / 20:22
0
answers

Remove quotation marks when uploading csv

I made the following statement to upload a csv to the database: public void importarBaseBruta(File arquivo) { try { this.limparBaseBruta(); this.con.conectar(); this.stm = this.con.getStm(); System.out.print...
asked by 10.07.2018 / 20:41
1
answer

date + 2 working days

I have a date ( fatura.baixaboleto , "%d%m%y" ) and in this query I want to add another 2 working days, eg: Day 16/07/18 + 2 working days = 18/07/18 (Monday through Wednesday) thursday to Monday) Day 20/07/18 + 2 worki...
asked by 20.07.2018 / 05:13
0
answers

Error executing a trigger ORA-04092: Unable to trigger

I have the following problem: - I can not execute a job (Scheduling) after an insert retrieved by the trigger.    Line 2: ORA-04092: Not possible on a trigger ORA-06512: in   "SYS.DBMS_ISCHED", line 135 ORA-06512: under "SYS.DBMS_SCHEDULER"...
asked by 20.07.2018 / 16:29
0
answers

Save a JSON in the database or create an intermediate table?

Good evening! I'm in a small Dilemma, I'm building an application for event control, in this application I have an event that can have multiple guests in the Front end I'm thinking of using a component equal to this: Anyway,whatwouldbethebes...
asked by 09.07.2018 / 03:20
1
answer

Consolidate all columns in only one row MYSQL

I'm trying to make a query that aggregates all the results in a single line, ie, does not bring duplicate results. I've already used distinct and group by but none of the two returned me what I need. My query is as follows:...
asked by 18.07.2018 / 01:27
3
answers

Difficulty installing SQL query

Personal oops. I'm having difficulty setting up a query in MySQL. It is as follows, I have a table with the following structure The time_array and time_azul columns store user IDs of the system. I need to look in the columns time_...
asked by 07.07.2018 / 01:08
0
answers

Automate table fill

I have a table with the following structure: id - email - activation_key I need to populate the activation_key column with a random key (I already have the script to create this key), only it's type, 200 lines, how can I go populating each on...
asked by 20.07.2018 / 20:51
1
answer

Lock log in SQL Server

Using SQL Server and Delphi, I need to control so that in a certain database table two changes can not be made at the same time in the same record, I can not start the update if there is already another change in progress. I need to know if this...
asked by 10.07.2018 / 15:01
0
answers

SQL add data from multi seconds

How can I make convert and add the last day of the previous month and the first day of the previous month when I have the date ( created time ) in milliseconds? The code is below: DATEADD(month, DATEDIFF(month, -1, getdate()) - 2,...
asked by 10.07.2018 / 17:05