drop table t;
drop table t_int;
create table t (
SQL> select listagg (b)
2 within group (order by null) ||' Batman'
3 from (select 0f/0 b
4 from dual
5 connect by level <= 14
Last year I did a presentation on table functions at KScope. One of the questions I got was: ‘If pipelined table functions provide their results faster, why would you want to use a normal table function?’ I couldn’t come up with the answer then, maybe you can help?
Erik van Roon
Let’s start with explaining a bit what table functions are. Table Functions are functions that return a collection of (more...)
Here is how you could make the same information available to touchscreen users.
1) First step, as before, is to define the HTML Expression of the column to include the title tag.
In this case I also stored my row identifier as an extra data- attribute.
<span title="#RECENT_NOTE#" data-key="#ROW_KEY#">#MY_COLUMN#</span>
2a) Create a dynamic action on click (more...)
- parallel (default): erzwingt die Verwendung des allgemeinen (also von den beteiligten Objekten unabhängigen) default DOP (der sich errechnet als: (more...)
What is an ANTI-JOIN? And what is the difference between the SEMI-JOIN and the ANTI-JOIN?
First of all, both SEMI-JOIN and ANTI-JOIN are not in the SQL syntax but they are more a pattern. You might expect to be able to write something like:
[PATRICK]SQL>SELECT d.deptno, d.dname, d.loc FROM dept d SEMI JOIN emp e ON (e.deptno = d.deptno) /
to get all the (more...)
You'll have many opportunities to catch up with Oracle Developer Cloud Service at Oracle OpenWorld and JavaOne this year.
The team will be at the Developer Cloud Service demo booth in the Moscone south exhibition hall, and we'll also be at the Oracle area at JavaOne.
There are multiple sessions and labs featuring DevCS here is a partial list:
However, it will only appear when hovering over the span content, not anywhere within the table cell.
$('td[headers=my_column] span').each( // for every data cell in the column
firstname.lastname@example.org > create table t( pk int primary key check(pk > 0)); Table created. email@example.com > insert /*+ignore_row_on_dupkey_index(t(pk)) */ into t firstname.lastname@example.org > select trunc(dbms_random.value(1, 1e5)) from dual email@example.com > connect by level <= 1e5 firstname.lastname@example.org > / 63187 rows created.
Finding the first n gaps
email@example.com > variable n number firstname.lastname@example.org > exec :n := 1000 PL/SQL procedure successfully completed. email@example.com > set autotr (more...)
- in einem neu installierten postgres-Cluster existieren zunächst drei Datenbanken: postgres, template0 und template1.
- die Datenbank postgres ist der default-Einstiegspunkt für viele Applikationen (etwa den pgadmin), kann aber - wie jede andere Datenbank - gelöscht werden, wenn keine Connections zur Datenbank existieren.
- man kann sich anschließend aber (more...)
Oracle Developer Cloud Service 16.3.5 introduces new enhancements for Deployments and integration with Oracle Social Network.
Deploy WebLogic Server Shared Libraries to Java Cloud Service
When selecting build artifacts to deploy to a Java Cloud Service instance, new options are available to deploy as a WebLogic Shared Library. The shared library can then be referenced by other running applications in the JCS domain.
Oracle Social Network Webhooks
The world is moving to https, but that was not the reason for the move.
Initially I was happy to use whatever Digital Ocean (DO) supplied in the WordPress droplet. But as I explained in my last post, I had some problems with moving from wordpress.com to my self hosted site at DO.
In short the problem turned out to be Chrome caching sites that accepts https making my site unavailable to every (more...)
This post is a quick summary of how to use inline dialogs. As John points (more...)
Q7. Do you utilise apex_workspace_activity_log (for monitoring/reporting application usage)?Yes (90) 47%
No (102) 53%
This log table reports details of all page rendering and AJAX process calls. I really like this information, though I would like to be able to add to the output things such as
In addition to the Monitoring pages you'll find in the APEX administration section, I've built (more...)