TweetShareSharePin0 SharesShort answer: No This blog post is pretty much just to document what seems to have been hard to find online. At work there was a big rework of a liquibase project due to the perception that “create or replace view” on an existing view would make the granted privileges be dropped. That was of course not what happened. The issue was that using liquibase the new version of the view was installed. Then the rollback was triggered and […]
Recent Posts
Your very own development environment
TweetShareSharePin0 SharesEveryone should have their own local development environment. No matter if you write Java and that just means IDE and JDG, or if you work with databases. Not having it reduces your learning a lot. I have yet to meet a really sharp database expert who does not have a local personal environment. It also goes the other way around, you can usually guess if a person has it or not. Yes, you can get a database by just […]
New Year, New You
TweetShareSharePin0 SharesWell maybe not so much a new you. More like getting your personal “play” environments refreshed. If you are anything like me, you want the latest and greatest in the setup where you play with great tech. I have always had database, ORDS, APEX, SQLPLUS and so on installed in a VirtualBox VM. It has worked great and while I was hesitant to jump on the Docker train it is clear that not taking advantage of it in 2019 […]
ODC Appreciation Day: Old Blog Posts
TweetShareSharePin0 SharesFIrst of all, kudos to Tim Hall. This is one of the great times of the year when all these thankful blogs are posted in a day. If you read nothing else in the blogs all year, picking some of them would not be a bad choice. Speaking of which, I will talk about being thankful for blogs in general. No, not about the new ones explaining all the new features we get in new versions. While that is […]
Customized help text in APEX
TweetShareSharePin0 SharesYes, I’m finally back. The last post was written right before a complete period of being offline, during that time it was scheduled to be published. Followed that was slow recovery. I have been deemed fully recovered for a while but not gotten back enough to find time to blog. That changes now. So what causes almost a half years time to recover. Going out with the trash. Yes, it really is dangerous and should be avoided at all […]
Help text as a modal dialog
TweetShareSharePin0 SharesTo continue on the theme of help text in APEX, let’s take a look at showing it in a modal popup dialog in this post and then finish off the subject in next post with customizing how help can be shown. For completeness I’ll include a short section towards the end about how it works in non modal too. In the last post I show how to show help text inline on a page and on the one before […]
Help text in APEX in-line with page
TweetShareSharePin0 SharesSetting up help text in APEX is not hard but I often see it not done at all or implemented using regions with static content and then toggled on or off. That is unfortunate when there is declarative support for providing help texts. In the last post I show how to set up a specific page to be the landing page for showing help text for any page in the application. In this post I’ll show how to get […]
Help text in APEX on a dedicated page
Use a dedicated page to show help text in APEX.
Database is the marquee feature again
TweetShareSharePin0 SharesSo every year before and during Oracle Open World we all complain about how data and database is brushed to the side. This year it is the feature. It is the one thing the big sign on Moscone West screams. “The Autonomous Database” Here is a picture from showing it. It is all about database. Every year there is talk about how Oracle needs to return to data and databases. Now that they do, I think we should be […]
Spam killed
TweetShareSharePin0 SharesAfter I moved my blog to self-hosting, it has attracted more and more spam. It started slow and very manageable. After my last blog post it got really bad. What started as a few spam messages a week, culminated with 30-40 spam comments per day. At that point I had completely lost any ability to sort through it. ‘I was so disheartened by this that blogging didn’t happen as I knew I had to solve this first. I thought […]