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
email@example.com > create table t( pk int primary key check(pk > 0)); Table created. firstname.lastname@example.org > insert /*+ignore_row_on_dupkey_index(t(pk)) */ into t email@example.com > select trunc(dbms_random.value(1, 1e5)) from dual firstname.lastname@example.org > connect by level <= 1e5 email@example.com > / 63187 rows created.
Finding the first n gaps
firstname.lastname@example.org > variable n number email@example.com > exec :n := 1000 PL/SQL procedure successfully completed. firstname.lastname@example.org > set autotr (more...)