Questions tagged as 'oracle'

Tagged questions
1
answer

Is a "Group by" possible for column content?

I was wondering if it was possible to use GROUP BY based on the date of a column, in this case the ANALYSIS column that creates groups whenever it finds 0, instead of the column. DIA MES YEAR TODAY TOMORROW ANALY...
asked by 25.10.2017 / 00:30
1
answer

Select with specific column - Oracle

I've been migrating to Oracle and found a question. In SQL Server I could do this: select coluna, * from tabela How do I get a similar result using Oracle 12c?     
asked by 11.06.2018 / 15:45
0
answers

Failed to convert to internal representation

Good afternoon, I'm working with Genexus Ev3 Up1 . I have a Data Provider that I search for a query and returns an SDT with the information, but the error in TOMCAT with the message:    java.sql.SQLException : Failed to convert to Inte...
asked by 11.12.2017 / 14:25
0
answers

Database with Municipalities, City, Neighborhoods [closed]

Does anyone know where I can get a database with *States * Counties * City * Neighborhoods in Brazil ?     
asked by 18.02.2018 / 03:25
0
answers

Knowing that Procedure or session is leaving open cursors

I would like to know if there is any way to find out what session or procedure (s) are leaving open cursors in Oracle, sometimes (not always) the error occurs:    ORA-01000: maximum open cursors exceeded     
asked by 02.10.2017 / 16:39
2
answers

Write values whenever a new line is added via trigger

I need help solving a problem, I tried halfway, but it is not working. I have two tables which I have to perform this activity and create a trigger called trg_line_total to write the line_total value in the LINE ta...
asked by 15.07.2016 / 17:21
0
answers

PHP with PDO returning BLOB records with foreach

Good afternoon guys, I'm new here (first question), but Stack has already helped me in many situations. Here's the problem: I'm developing an application and on a certain page there is a user profile page. On this page, a div that displays...
asked by 05.01.2017 / 20:39
1
answer

Transaction control between two different applications

I'm working on an application that is split into two modules, each in a language (.NET and Java). The A (.NET) application will manipulate the records of a table while the B (Java) application will handle it at the same time.    Scenario:...
asked by 31.07.2016 / 14:59
2
answers

ORA-22922: nonexistent LOB value in SELECT

I'm facing a problem with two separate queries in oracle . Both have the sql% share of% The error that returns is REPLACE(dbms_lob.substr(wm_concat(disctinct <COLUNA>)), ',', ', ') . I looked for the error in ORA-22922...
asked by 11.04.2016 / 22:24
1
answer

Spool task for the server

Good evening! Personal, currently in my work, I have to generate multiple .txt files to be exported to the bank of another company. I flip this in hand and that sucks, every day I run, wait to send and everything. I tried to do the spoo...
asked by 11.11.2015 / 21:57