Oracle PL/SQL

/Oracle PL/SQL

Convert RGB to Hex with PLSQL

With a very simple table structure, we Convert RGB to Hex with PLSQL. With small effort, you can display these colors in your applications. So why not have a color table? Then you too can flow color name to hex or RGB colors on demand within an Oracle APEX application.

By |2018-10-10T08:54:53+00:00May 16th, 2016|Oracle PL/SQL|Comments Off on Convert RGB to Hex with PLSQL

Synchronize Sequence with Primary Key

Whilst migrating to Oracle 12c, it is clear that we will still have primary keys populated by sequences for years to come. When I pull production data over to our development server, I dread the steps required to synchronize the old sequences to the updated tables. Using the expdp / impdp, moving the tables has become routine and risk free.

By |2018-10-10T08:57:54+00:00January 31st, 2016|Oracle PL/SQL|Comments Off on Synchronize Sequence with Primary Key