About The solutions of PL/SQL challenges on w3resources executed on Oracle environment compiled with helpful Resources & references related to the challenges.

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored procedure.<BR ...

plsql code fails with variable referencing a table column type in Oracle nested procedure #19827 ...