Questions tagged as 'pl-sql'

Tagged questions
1
answer

Is there any function to calculate the trend line in PL SQL?

Good morning everyone. I need a function to calculate a trend line. I have a query (part of the function): select round(sum(nvl(vl_indice, vl_meta))/12, 2) from ( SELECT SUM (vl_indice) vl_indice, SUM (vl_meta) vl_meta FROM (SELECT cd_mes...
asked by 11.05.2016 / 16:29
1
answer

I should not display negative results

I put a query where I bring some information, of which the last column returns positive, negative and zero values. I do not want to display the rows with negative values, but I'm not sure how to do that. This is Query SELECT C.SG_CONCESS...
asked by 31.07.2015 / 22:08
1
answer

Call procedure dynamically

Does anyone know a method for calling a procedure dynamically? I'm creating a html / css / javascript screen in an oracle procedure. I created a table with the name of the procedures I want to call. That way when there is a new functionality...
asked by 08.07.2015 / 21:51
1
answer

Delete in the table via Shell Script

I'm trying to do a delete of all rows from a table via Shell Script. The database is oracle. The bank for some reason does not let me do truncate and the delete simply does not delete, without presenting any error. I do not really know why, when...
asked by 24.05.2014 / 00:29
1
answer

Stored Procedure with low performance

I have a problem with Oracle, where I have two procedures that are executed one after the other. Where in the first procedure , I have a cursor that makes insert in a table. This insert has approximately 30 million records , which...
asked by 21.10.2014 / 15:09
1
answer

Conditional to print in PL / SQL

I have a report developed in Sybase InfoMaker (similar to Crystal Reports) which displays two pages, however I need to print the second page only if there is a calculation. On the second page you see several calculations, but if the report (p...
asked by 19.04.2014 / 17:55
1
answer

How to pass the schema param param in PLSQL?

I have a function that receives a value in varchar2 with the name of Schema in order to write the data in the database but in the informed schema. create or replace FUNCTION hospitalTeste123(MatriculaMedico in number, nomeSchema in varchar2 )...
asked by 16.05.2018 / 16:07
0
answers

Oracle PL / SQL - Connection with Webserver SEFAZ

Has anyone here been able to establish and authenticate SEFAZ (NF-e or Reinf) servers via PL / SQL with Oracle Wallet? For the last few weeks I have been trying to establish contact with these webservers, first with Oracle 11, and then with O...
asked by 01.08.2017 / 14:47
1
answer

Table Update Update Doubt

I have two tables, questions and answers, and I would like to update them according to what is selected: Bank Sql Server 2005 Problem: --usuário excluindo a pergunta (não está gravando a data da exclusão é não está excluindo as perguntas) u...
asked by 03.07.2015 / 04:28
0
answers

getting array plsql in javascript

I created a cursor in pl, now I'm trying to pass the records to a array of the javascript to create graphics, newData will receive the cursor data. Javascript created is this: <html> <head> <script type="text/javasc...
asked by 07.07.2015 / 20:10