Comparing the results of 2 queries is a task more complicated than I thought initially.
I show some more pitfalls of the MINUS approach (which I still find convenient in some cases) and alternatives.
I’m now an official Oracle ACE, which means a lot to me.
What it means and what it does *not* mean is what I want to share in this post.
The context-feature of #utPLSQL can greatly help to organize your tests and reduce the setup/teardown time of tests.
Learn how to use them to test the Deathstar security system.
#100CodeExamples
My personal review about the APEX Connect 2019: A great conference, driven by great people, led to a great experience.
There is a lot of suffering in tech and we can witness it on several levels every day – from flaws in our little tech helpers to the usage of derogative language towards others and ourselves.
Learn about a new movement in software development called Compassionate Coding and how you can use this human-centered, agile development approach to improve the quality of your own life and the life of people around you, to create better products and software and make them serve the people.
I’m very excited and looking forward to speaking at #apexconn19 next week.
See what I’ll be talking about, how to get the slides and how to get in touch with me (fighting the awkwardness!)
I am working professionally with databases for over 15 years now and have a huge focus on Oracle – but I really keep forgetting how to update a table with values of a different one (this is one thing which is so much easier in SQL Server by the way).
Therefore let’s assume we have a table containing planets and one containing garrisons which are on these planets.
| Garrison ID | Planet Name | Planet Faction |
| 1 | Korriban | imperium |
| 2 | Korriban | imperium |
| 3 | Dromund Kaas | imperium |
| 4 | Hoth | republic |
We would now like to have a new column in the garrisons table which can contain a name.
alter table garrisons add name varchar2(300)
The imperial side now has a request to update all their garrisons with a name according to this schema: <PlanetName> (<Garrison ID>)
(more…)The MINUS comparison of two views (or other statements) is a powerful tool to check the validity of a new, rewritten approach I use often.
However, be aware of
I’m a strong cricitc of the attention-driven industry and for my blog ran on the free plan WordPress-platform I considered moving the whole blog to a static site – not noticing I was about to shave a Yak…
If it comes to testing updatable views, the use of nested tables from ROWTYPE records in combination with utPLSQL’s cursor comparison is invaluable.