Category Archives: PL/SQL

EBR – Part 11: Database-Level Default Edition

Oren Nakdimon Leave a Reply

This is part 11 of a post series about Oracle Edition-Based Redefinition. Visit the index page for all the parts of the series Introduction As we’ve seen in the previous posts, the process of an online application upgrade, in high level, includes the following steps: Creating a new edition Applying all the necessary changes in […]

Continue reading

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