Questions tagged as 'pl-sql'

Tagged questions
0
answers

Generate field Xml file in Oracle

I have a problem to solve: I have a table in Oracle 11g that stores the company entry notes, in this table I have a column of type CLOB that stores the complete XML file of the note, my mission is: get this column of the CLOB type with the XML a...
asked by 07.02.2018 / 11:34
1
answer

How to display two tables in SQLDeveloper at the same time?

I'm not able to filter two tables at a time in SQL Developer at the same time. When I insert two tables into it, sqldeveloper does not show anything!     
asked by 25.01.2018 / 20:57
1
answer

How to run PROCEDURE and FUNCTION at the same time?

I have this plsql code and I must run at the same time: /*Testar se o codigo é valido*/ CREATE OR REPLACE FUNCTION TESTE1(cod number) RETURN BOOLEAN IS begin if(cod>0)then return true; end if; return false; end; /*varrer o b...
asked by 23.01.2018 / 17:08
0
answers

Error displaying message in PL-SQL

Code DECLARE BEGIN FOR I IN (SELECT * FROM PRODUTOS_TESTE2) LOOP DBMS_OUTPUT.PUT_LINE(I.codigo|| ' - ' || I.categoria || ' - ' || I.VALOR); END LOOP; END; Error message: Relatório de erros - ORA-06550: line 5, col...
asked by 24.01.2018 / 21:43
0
answers

Error oracle ora-06550 pls-00103:

I have this PL-SQL code: /*1. Criar um bloco PL/SQL anônimo para imprimir a tabuada abaixo:*/ DECLARE VN CONSTANT NUMBER(2) := 5; BEGIN FOR i IN 1..1O LOOP DBMS_OUTPUT.PUT_(VN || ' X ' || i ||'='|| VN*i); END LOOP; END; Er...
asked by 25.01.2018 / 05:32
0
answers

How do I sweep a string and bring different parts of it?

Using REGEX is it possible to "concatenate" masks to bring different parts of the same string? How do I sweep a string and bring different parts of it? I have a text field with the following information:    00200.035219 / 2012-15 (VOL...
asked by 26.01.2018 / 17:46
1
answer

Select the value of a field depending on a date

I have a table with the fields DT_FIMCALCULO, VL_DEPREREVVIDAUTILACUMULADA and CD_SEQUENCIALBEM. And for each CD_SEQUENCIALBEM I have several DT_FIMCALCULO each with a different VL_DEPREREVVIDAUTILACUMULADA. I want to select the VL_DEPREREVVI...
asked by 19.12.2017 / 13:19
0
answers

INSERT clause ignored in procedure

I have a problem that I am already thinking of as a lack of faith. I have a proc that performs a series of inserts and updates . It goes through the first insert and the first update and performs what is proposed. In the inserts , the...
asked by 01.11.2017 / 13:19
1
answer

Calculation in SELECT oracle

Good morning. I need to calculate between values that are stored in my DB, these values are marked with the + and - sign in their respective tables. I would like to know if there is any way to do that through a single SQL command I make these ac...
asked by 19.10.2017 / 21:01
1
answer

"ORA-01417: a table may be extra joined to at most one other table"

I'm setting a select and I came across the following error:    ORA-01417: a table may be extra joined to most other table SELECT A.SEQPESSOA, A.NUMERONF, A.NROEMPRESA, A.SEQPRODUTO, D.SEQCONTRATO, E.PERCDESCONTO, D.SEQCONTRATO, E.SE...
asked by 26.06.2017 / 23:17