Posts by Yves Gasana • 11 points
2 posts
-
0
votes1
answer97
viewsA: Oracle PLSQL - How to get the lowest and highest value from a list of values in a range?
I was able to develop a solution, however, at the operational level, it may not have the desired performance, but the low scale meets 100%. create or replace procedure insert_compactado is cursor…
-
0
votes1
answer97
viewsQ: Oracle PLSQL - How to get the lowest and highest value from a list of values in a range?
CREATE TABLE TABELA_PRAZO ( CEP_INICIO NUMBER(8) NOT NULL, CEP_FIM NUMBER(8) NOT NULL, PRAZO NUMBER(3) NOT NULL ); insert into tron2000.TABELA_PRAZO(CEP_INICIO, CEP_FIM, PRAZO) values (1000000,…