Searching orders for SEARCH ALL can be either ASCENDING or DESCENDING. ASCENDING is the default one. If you want the search to be done on an array sorted in descending order, then while defining the array, you should give DESCENDING KEY clause. (You must load the table in the specified order).
Posted Date:- 2021-09-03 06:03:38
You are writing report program with 4 levels of totals: city, state, region and country. The codes being used can be the same over the different levels, meaning a city code of 01 can be in any number of states, and the same applies to state and region code so how do you do your checking for breaks and how do you do add to each level?