Questions tagged as 'oracle'

Tagged questions
0
answers

Process does not start in Oracle BPM Player 12c Player

I created a process using Oracle BPM Composer 12c, I am not able to start the Player to test the process before publishing to the domain. When I click the Player button it generates the following error in the server log:    There was an er...
asked by 24.11.2015 / 18:11
0
answers

How to fix intersection points to calculate the distance between points?

I need to calculate the distance between points within the place where I work, so I calculated the coordinates of each location in X and Y and put coordinates in the system. I am doing query to calculate this distance, but since it is...
asked by 05.07.2016 / 12:49
2
answers

Translation SQL script for Oracle

I have the script below in SQL Server, but I need to mount it in Oracle. I do not know anything about Oracle and I could not make it work. can you help me? Oracle: 11.2.0.4.0 SQL Script: DECLARE @DataExec datetime DECLARE @DataRef datetim...
asked by 10.10.2016 / 16:06
4
answers

How to do an update with inner join in Oracle

Good afternoon, How do I update with inner join, since I need to change the field idnaoleitura = 24 to idnaoleitura = 0 where the idrota in (35,45,48,53,60,68,70,79), remembering the idrota is in another table. The calculating_table_count...
asked by 15.07.2014 / 18:07
3
answers

Viability to create 200 columns in database [closed]

I am planning software, which is a test of 200 questions where each question can only have 3 choices and select only one, and each question belongs to a class type (eg question 5 belongs to class B , are classes from A to J) and I need to save t...
asked by 28.03.2016 / 20:35
2
answers

My dbms output is not displayed

I'm testing a simple output of DBMS in SQLDeveloper. I created the connection, I executed set serveroutput on to enable the DBMS outputs, but when I run my anonymous code block, in Saída do Script it displays the mess...
asked by 27.11.2017 / 17:56
2
answers

I can not read the values returned from the database using OracleDataReader

I'm having trouble reading the returned values from a select , on the line where I do: OracleDataReader reader = cmd.ExecuteReader(); In read it brings me the values correctly, but on the next line where I do reader.Read()...
asked by 14.05.2015 / 18:29
2
answers

How to check day and month birthday in SQL in Oracle?

I've seen some examples here, and I've tried to reproduce them, but in oracle does not accept operators like MONTH , so I was not successful. SELECT nome from aluno where month(datanascimento) = month(now());     
asked by 11.08.2018 / 16:35
2
answers

Convert data to dd / MM / yyyy ORACLE

How to format sysdate for dd / MM / yyyy in Oracle 11g?     
asked by 21.08.2015 / 03:07
4
answers

Orable DB and MVC 4 - Connection Error (ORA-06413)

I have a dll that is responsible for performing queries in the database. In this dll , in the connection class, I have a method that opens the connection to the database and returns the connection, as seen below: private OracleCon...
asked by 13.10.2015 / 15:41