A Christmas tree generated in PL/SQL

In the previous post “in cooperation” with AI, I generated a Christmas tree.

But I felt unsatisfied. Everything was hardcoded. That just couldn’t be right!

I wanted the tree to be green instead of white, to be able to choose its height, and for the ornaments on the tree to be generated randomly, in random colors.

Because what else is there to do on winter evenings if not to program a Christmas tree in PL/SQL?

Merry Christmas!

The code is available here:

specyfication

body 

You can generate the tree using SQL:

select * from tree_pkg.gen_tree(:TreeHeigh);

 or PL/SQL 

exec tree_pkg.gen_tree(:TreeHeigh);