Questions tagged as 'oracle'

Tagged questions
0
answers

Different results 'count (*) from V $ ASM_DISK'

I have a script that connects to an Oracle database and then selects: select count(*) from V$ASM_DISK; This script is in a .sql file, so I make the following call in the OS: "$ORA_HOME/bin/sqlplus -L -S xxxx/xxxx @query.sql"; When exec...
asked by 20.06.2018 / 17:36
0
answers

Visual Attribute in Oracle Forms Personalization

I'm having a problem with Forms Personalization , I'm new to Oracle EBS and Forms Personalization . I need to change the background color of my item, but when I use the background-color property, it changes the entire column, I want...
asked by 19.06.2018 / 16:05
1
answer

Delete Oracle - Api Web

I'm trying to make this springboot code, turn a code into WebApi @RequestMapping("/deletarEvento") public String deletarEvento(long codigo) { Evento evento = er.findByCodigo(codigo); er.delete(evento); return "redir...
asked by 26.05.2018 / 19:19
0
answers

SELECT Invalid identifier

I'm having problems where I use {Routes}.[Qualquer] in subselects . The error returned is    "ROUTES". "COLUMN": invalid identifier. I tried to expose the column in select but continue with the same error. SELECT /* ROUTEID */...
asked by 24.05.2018 / 13:14
0
answers

Procedure with EXECUTE IMMEDIATE

I created a script in Oracle that runs on one owner, makes the select on several others and makes insert or update on another owner on another server through a linkedserver. Due to the fact that I select in several owners, I created the selec...
asked by 08.05.2018 / 18:49
1
answer

Multiply two columns in a select

I have two columns ( valor_unitario and quantidade ) I wanted to make a select that multiplied all the columns of the valor_unitario * quantidade field. Example: Valor_Unit|Quantidade 15 * 2 + 10...
asked by 17.05.2018 / 15:35
1
answer

Error when adding FK

I found only this type of error in "Select", I followed all the restrictions but it did not work! Error from line: 86 in command - alter table tb_consulta add constraint fk_tb_consulta_tb_tratamento foreign key (idtrat) references tb_pacien...
asked by 28.04.2018 / 19:47
2
answers

Create a Sequence, through a trigger. Oracle

I'm trying to create a sequence in a trigger . When trying to create by Execute Immediate , I'm having the following return:    ORA: 4092 - Can not commit in a trigger. For all I've ever researched, using Execute...
asked by 16.04.2018 / 21:07
0
answers

Loop, For, PL / SQL Cursors (Doubt)

Good morning, my doubt is as follows, my table is like this currently: Nome Idade ID João 5 Lucas 5 João 2 Lucas 1 I wish it looks like this: Nome Idade ID João 2 1 João 5 2 Lucas 1...
asked by 30.01.2018 / 14:04
0
answers

Missing Task SrcSet0 (Loading) in source MICROSOFT_EXCEL ODBC

Hello, I'm trying to set up oracle data integrator to read an excel spreadsheet in xls and xlsx formats, but I'm having problems and I can not find a solution! it returns me the following error: IconfiguredODBCinthisway: Andtestingthesepara...
asked by 27.12.2017 / 12:48