I ran into a problem in my project, I have to decide whether there is a string in a list of strings is null or not. The problem is we have two columns from the Oracle DB: first_name, last_name, both of them could be null, we need to format the fullname like "last_name, first_name", but we do not to have the ',' if either last_name or first_name is null. Here comes my solution:
select last_name || nvl2(length(last_name) * length(first_name), ',', null) || first_name from contact_info;
Full Guide for using Bitnami Prometheus Operator Helm Chart with Additional Scrape Configuration
"The Prometheus Operator for Kubernetes provides easy monitoring definitions for Kubernetes services and deployment and management of...
-
After some digging, finally I got android market working on Android emulator 2.2 running on Windows Vista. Here is the steps,: Start SDK Set...
-
"The Prometheus Operator for Kubernetes provides easy monitoring definitions for Kubernetes services and deployment and management of...
-
Thingsboard is a fantastic open source IoT data gathering and visualization platform. I was trying to setup the local development mode for ...
No comments:
Post a Comment