Questions tagged as 'oracle'

Tagged questions
1
answer

Verifying that the database column value contains only numbers in the select

I need to find out if the value of a given column of the database contains only numbers in the select itself, because if it is numeric, I need to display the value of another column. I use an ORACLE database. Can anyone help me with this p...
asked by 30.03.2017 / 19:55
1
answer

How to use an Oracle database and a Sql Server simultaneously with Entity Framework 6 in a single application?

I'm developing an application where information will be persisted in two databases, one MS SQL Server and one Oracle. I have no option to use the two banks in the same DBMS, because the Oracle database is from another application and another...
asked by 29.12.2016 / 13:09
0
answers

Display button after submitting page oracle apex

I have a test page on link user test password, which is already working ok in general It migrates employees using a shuttle object, and uses collections to update the information. So far so good. It happens that I do not want to leave enabled,...
asked by 11.02.2017 / 21:48
1
answer

Make a select according to an indexed table

I have a table, getSalas , which simplified something like this: CREATE TABLE getSalas( ID_SALA NUMBER(4), NOME_CARATERISTICA VARCHAR2(20), VALOR_CARATERISTICA NUMBER(4) ); The contents of this table are of the type:    1, '...
asked by 26.01.2017 / 14:04
1
answer

Get procedure return in Oracle

I need to execute a procedure in the database (Oracle) that returns me a character (S or N), I'm using the ODP.NET driver, I've tried everything and I could not do this, I even looked at several answers right here in SO PT and OS EN as well....
asked by 07.12.2016 / 17:56
1
answer

Difference of character enconding Charset difference using JPA but not with prepared statement

I have an application using spring boot + oracle (via tomcat datasource). Using spring-data, a simple query in a table returns characters with an encoding problem. This same application, in a very specific situation, I create a direct (no dat...
asked by 23.12.2016 / 01:13
3
answers

join with two tables and a varchar2 field

Hello. I'm using oracle 11g. I'm trying to search a status table for a certain city. For example, the state of Bahia has several cities. If you are informed of Salvador, you should return Bahia state. The query I'm trying to do is: selec...
asked by 27.11.2016 / 20:32
1
answer

Group values from different columns into one, separated by commas

I have the following select : SELECT DISTINCT ORGAO, UNIDADE FROM TESTE Where the following result is generated: Órgao Unidade 1 2 1 3 1 4 1 5 4 records of the same organ are returned, but with different units. Wh...
asked by 01.09.2016 / 23:13
1
answer

How can I run a .rdl file (Reporting Service) with Report Viewer without using the server?

Good afternoon, I need a solution to run the local .rdl files without using the Report Services server, I need to use the local file. The goal is to use existing reports, with SQL Server and Report Services, in another database. Anyone have any...
asked by 16.03.2016 / 18:55
0
answers

The parameter I use is not returning anything when I run the proc in the test by the package

I have a procedure that when I make the query in it I have the correct results. However, when I pass via parameters in the plsql Debug it does not consider the field in question. The field is the same type as the table (varchar2) and the othe...
asked by 13.07.2016 / 13:38