Are there examples of serious PL SQL procedures in the public domain?

Question

Oracle

At work, PL SQL stored procedures are used, which are very simple from a technical point of view. Initially, I did not know PL SQL at all and used these procedures as a guide - I googled all unfamiliar constructions until there were none left. I want to study the language further in order to somehow improve these procedures, and in the future to add the necessary functionality myself. I tried to just read the Oracle documentation, but the method for learning is not very effective and is more suitable for clarifying the details of how this or that construction works. But how it is effective and in what cases to apply it at all is not always even clear.

Does anyone know of sources where I can look up good complex code examples in PL SQL? So that I can learn from the original scheme - see how something is used in practice and google how it works.

Answer 1

OTN Will
always help.
Right there and look for