Posts by Edumelzer • 161 points
3 posts
-
1
votes3
answers1756
viewsA: How to declare a cursor variable in PL-SQL?
So that you can use the variable in any chunk of code, even outside of a loop, or even as a filter for another cursor, you can declare a variable using %rowtype, as an example: declare -- cursor…
-
1
votes2
answers39
viewsA: How to correctly display data from a commemorative date table
You are using AND in all conditions, but in fact you need to filter if the day is longer than 15 only when the month is 01, and smaller than 15 only when the month is 02. Try the following query:…
-
1
votes1
answer1960
viewsA: How to call another Procedure or Function within the same Packge in oracle?
If you declare the objects only in the package body, just make the statement in order for the reference to work (i.e., declare TOTAL SUM before CLOSE box). If you declare the objects in package…