According to the doc The subquery_factoring_clause now supports recursive subquery factoring (recursive WITH), which lets you query hierarchical data. This feature is more powerful than CONNECT BY in that it provides depth-first search and breadth-first search, and supports multiple recursive branches. A new search_clause and cycle_clause let you specify an ordering for the rows and […]
Month: May 2010
CONNECT BY and Recursive CTE
11gR2 introduced a new mechanism to build up hierarchies. I remembered a thread in developpez.net that reveals the dubious implementation of nocycle in 10g. For the CONNECT BY ISLEAF, I have read the technique on amis.nl. Ok, here is my graph The 10g query with o as ( SELECT ‘A’ obj, ‘B’ link from dual […]
read without Enter
A small unix tip today. Do you want to continue ? If you are expecting “y” or “n” but do not want to enforce the user to type y[Enter] but simply y, you can use the -n option in bash. Within a ksh script: yorn=$(bash -c ‘read -p “Do you want to continue ? ” […]
number series
Patrick Wolf wrote about the newest Apex release, which contains a 11.2 db engine, so I had to play with recursive queries 😉 with t(x) as (select 1 from dual union all select x+1 from t where x
where is the TRIGGER ANY TABLE privilege?
You have your table data in one schema and your procedures in another one. But can you have triggers and tables in different schemas? SYS@lsc01> create user u1 identified by u1; User created. SYS@lsc01> create user u2 identified by u2; User created. SYS@lsc01> grant create table, unlimited tablespace to u1; Grant succeeded. SYS@lsc01> grant create […]
what’s up last weeks?
I just came back from diving, parasailing, safari and more fun in Egypt. On my blog I saw a comment from Nicolas regarding the availability of the terminal patchset for 10gR2 Note 161818.1: Oracle Database Releases Status Summary 10.2.0.5: Patchset 8202632