Questions tagged as 'oracle'

Tagged questions
0
answers

Error: ORA-01461: can bind to LONG value only for insert into a LONG column

I'm getting this error in Oracle.    Error: ORA-01461: can bind to LONG value only for insert into a LONG column When running the code below that the error is displayed, I would like to know how to solve this problem in Node.js. The CO...
asked by 11.10.2017 / 20:31
0
answers

Change MySQL query to work in SQL Server and Oracle

Would anyone know how to tell me how this MySQL query would look like in SQL Server and Oracle? SELECT COUNT(*) AS TOTAL, SUM(EVENTO = 7 AND RESULTADO = 0) AS QTD_RX_OK, SUM(EVENTO = 7 AND RESULTADO <> 0) AS QTD_RX_ERR, SUM(...
asked by 25.09.2017 / 16:48
2
answers

SQL result in columns

I have an Oracle SQL query that returns records per line, and I wanted to turn this into column. I've researched and found that Pivot does this, but I'm not sure how to use it, can anyone help me? CURRENT RETURN: SELECT AFD.CODEMP AS...
asked by 19.09.2017 / 22:35
2
answers

Hibernate does not close connections / sessions in DB

I'm having a problem using Hibernate. Each time I call a method that performs a query or update in the database, hibernate opens a session in the database and then does not close. I have tried everything, but really every time it is called the e...
asked by 15.09.2017 / 04:52
0
answers

Failed to update in registry

I'm having the following problem, when I try to change a registration made by my application, it creates a new registry instead of changing. My question is, if when I do the trigger insertion of the sequence , I should change to...
asked by 03.09.2017 / 07:30
1
answer

String problem in oracle

I am making a condition to add a field in the database, that is, it will only add if the condition is equal to 0. The problem is that in my execute immediate statement it says that the word PRIMARY is invalid. This is because it should be in si...
asked by 01.09.2017 / 16:20
1
answer

SQL Invalid Identifier Error (INNER JOIN) [duplicate]

Select a list of employees who switched from office to department (% with%), the list should contain the registration and name of the employee, the name of the department and position that worked, and also the start and end date ( job_hist...
asked by 29.08.2017 / 23:34
1
answer

Using "select" in sql (oracle), failed to fetch

I have to solve the following question:    1.CONSULT THE NAME (DESCRIPTION) OF THE PRODUCTS ACQUIRED BY HOOPS AND GOOD SPORT CLIENTS IN 1990. The command used for the search was: select p.DESCRIPTION from PRODUCT p, SALES_ORDER s, ITEM...
asked by 30.08.2017 / 06:24
1
answer

Update oracle with different information

I'm trying to do an oracle update with completely different information and I do not know how to do it. I want all other campuses to be the same as campus 1, where this id_campu is a foreign key with another table. Example: col1.id | col2....
asked by 10.08.2017 / 00:55
1
answer

Change column from date to timestamp

I have a table with a column of type date but I need to see the GMT information, my idea is to convert it to timestamp . How can I change this even if the column already contains value? create table PRO_TFESTIVO ( oid_festivo...
asked by 25.07.2017 / 16:21