Dynamic actions are awesome.
Let's so you have a scenario where after you change the value of one item, you would like to validate it or perhaps calculate the value of a separate item - or both!
Given an entry of Radius, I would like to calcular Sphere area.
Sometimes to get the data displayed exactly how you want it, you need to employ some nested functions.
with t as (
select null n from dual union all
select 0 from dual union all
select 0.5 from dual union all
select 4 from dual union all
select 4.5 from dual)
select to_number(n) verbatim
It can be fairly simple to configure your APEX application to authenticate against your Active Directory server - this means your users can use the same username/password as the use to log onto their desktop machine - a big plus.
Declarative definition can be as simple as heading to Shared Components -> Authentication scheme and selecting 'LDAP Directory' from the scheme gallery.
Settings might be as simple as:
Host : myserver
Not all regular expressions are scary.
As the documentation states, REGEXP_COUNT returns the number of times a pattern occurs in a string.
We can do this to simply count how many times the letter S appears in a string
select job, regexp_count(job,'S')
Creating triggers, prior to 11g, would default them to an enabled state.
From 11g, we have this in the documentation:
By default, a trigger is created in enabled state. To create a trigger in disabled state, use the DISABLE clause of the CREATE TRIGGER statement.
So when I write my DDL scripts, given this behaviour, I know what I'd prefer:
SQL> create table test_table(a number);
table TEST_TABLE created.
One of the reasons I
called renamed this blog grassroots-oracle was to occasionally illustrate some simple examples of functionality not everyone is aware of - or are maybe too scared to give it a go (or research).
Still today I occasionally work with people who aren't familiar with some features I almost take for granted.
Today's little observation was with ROLLUP - a function used in
group by queries to provide sub-totals.