Another Oracle feature that I would like see added to is some sort of collections in the procedure language. The ability to have arrays at a minimum would be very beneficial. Oracle's collection handling is very robust with arrays of records, nested tables, non integer indexes that can be indexed on, and more.
I had a case the other day where I had 24 integer variables and need to programatically adjust some of them. Without an array, I had to write a case statement that looked at my index and operated on the correct variable. I was converting code that was using a GT table, so even with the case statement the code was much faster than what I was converting. But it would have been a couple of lines in a loop from 1 to 24, and ended up being a long case statement.
Arrays can also reduce the number of parameters that are used. In the example above I was passing the 24 variables to a stored procedure because I wanted to encapsulate the logic, as it was spread in multiple places throughout the application.
We port a lot of code back and forth between the 2 environments and the more features that are in the SQLA language the better. A lot of really good stuff has been going on with SQL Anywhere over the past few years, but the programming language has remained somewhat static.
answered 05 Aug '10, 16:08