In this last chapter I’d like to consider specific real-life tasks and their solutions in SQL to demonstrate the power of Oracle SQL. The complexity of the tasks will vary a lot as well as the depth of analysis for different solutions. For a few tasks there will be both SQL and PL/SQL solutions, but the main accent in this chapter is on SQL capabilities.
For the sake of simplicity I tried to eliminate all the unnecessary details and make the problem formulations as simple as possible.
Converting into Decimal Numeral System
We have a string of symbols in some alphabet, and the goal is to convert ...