Category Archives: PL/SQL

EBR – Part 9: Adding a New Column

This is part 9 of a post series about Oracle Edition-Based Redefinition. Visit the index page for all the parts of the series Introduction In part 7 (“Editioning Views”) I introduced our third development use case – adding a new column that represents a new business logic. I emphasize the fact it’s a new business […]

Continue reading

EBR – Part 8: The Last Planned Downtime

Oren Nakdimon 1 Reply

This is part 8 of a post series about Oracle Edition-Based Redefinition. Visit the index page for all the parts of the series Introduction I concluded the previous post by stating that the application code should never reference tables directly; instead, every table should be covered by an editioning view and the application code should […]

Continue reading

EBR – Part 7: Editioning Views

This is part 7 of a post series about EBR. Visit the index page for all the parts of the series Introduction Our next use case is adding a column that represents a new logic to the PEOPLE table, and making the corresponding changes in the PEOPLE_DL and APP_MGR packages. Of course, as we speak […]

Continue reading

COLLECT INTO inside a Cursor Definition?

Oren Nakdimon 1 Reply

I have been programming in PL/SQL since 1993, more or less continuously (I’ve just realized that it’s exactly half of my life until now), so I know the PL/SQL syntax quite well. So when I saw the following piece of code a few days ago, I was willing to bet it would not compile: declare […]

Continue reading

EBR – Part 1: Overview and Setup

Oren Nakdimon Leave a Reply

This is a link to an index page for all the parts of the series I have been using EBR in a real production system for more than 4 years now. EBR – an acronym for Edition-Based Redefinition – is a powerful and unique feature (or, more precisely, a set of features) that enables patching […]

Continue reading