Saddened but not surprised to see COALESCE lagging behind NVL.
Why? Because I think coalesce
is a good idea and the modern equivalent of NVL.
I follow @SQLDaily
for useful tips. Oracle SQL evangelist Chris Saxon
runs the feed.
Full and utter credit goes to the gang at CommitStrip, you should check it out.http://www.commitstrip.com/en/2016/06/20/coder-bingo/
I thought a few choice replacements would help Joel Kallman and team rip into what I'm sure will be another stellar set of Sunday Symposium in Chicago.
|Credit to CommitStrip, text modified from original|
We'll be listening around the world, keep your tweet
If you have one record where you want to display multiple columns of information, the 'Value Attribute Pairs - column' report template is pretty nifty.
Some of the packaged applications use this within the breadcrumb bar, above a region display selector, and it looks really tidy.
|Nulls shown with tilde|
Note, I've modified region attribute setting 'Show null values as' to a tilde (~).
But what if I wanted to hide those null values for (more...)
The 'grand algorithm' favoured this particular tweet from Connor McDonald in my 'highlights'.
I found this intriguing considering a side project I've been tinkering on. The solution ended up looking much simpler than a model clause, though I'm going to need to let it digest for a while before I fully understand how
it works. Maybe read (more...)
If you've ever used a PL/SQL dynamic action with the default 'wait for result', you would have seen the following warning if you have the browser console open.
|Text for bots: Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience.|
Consider this scenario of dynamic actions on change of P42_ITEM:
|Synchronous vs Asynchronous server calls|
Next question in my 2015 survey
, how many different ways can we all type "chrome"?
Q4: Which browser do you use for development?
The first free text question, with a long variety of unique results. I haven't analysed the complete list to get a truer result, but the pattern is clear. 3 of the top 5 are Chrome. APEX developers build in Chrome, the application builder is recommended for Chrome, especially during early adopter (more...)