Oracle SQL Revealed: Executing Business Logic in the Database Engine

© Alex Reprintsev 2018

Alex ReprintsevOracle SQL Revealedhttps://doi.org/10.1007/978-1-4842-3372-6_12

12. Solving SQL Quizzes

Alex Reprintsev¹ 

(1)

London, UK

 

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 ...