baur b. posted an article on Baurdotnet’s Weblog - Aug 26, 2009, 11:58 pm
data MNTH SM 1 10 2 20 3 30 4 40 WITH t AS ( SELECT 01 mnth,10 sm FROM dual UNION ALL SELECT 02, 20 FROM dual UNION ALL SELECT 03, 30 FROM dual UNION ALL SELECT 04, 40 FROM dual ) SELECT mnth, s...
Comment - Like

baur b. posted an article on Baurdotnet’s Weblog - Aug 26, 2009, 6:28 am
data mnth CITY SUMMA 1 11 1 1 22 25 1 33 1 2 11 52 2 22 3 2 33 3 3 11 3 3 22 65 3 33 6 WITH t AS ( SELECT 1 mnth, 11 city, 1 summa FROM dual UNION ALL SELECT 1 mnth, 22 city, 25 summa FROM ...
Comment - Like

baur b. posted an article on Baurdotnet’s Weblog - Aug 26, 2009, 12:21 am
SELECT * FROM (SELECT ROWNUM t FROM DUAL CONNECT BY LEVEL < 6) JOIN (SELECT v, ROW_NUMBER() OVER(PARTITION BY v ORDER BY 1) rwnm FROM (SELECT 1 v
Comment - Like

baur b. posted an article on Baurdotnet’s Weblog - Aug 18, 2009, 7:09 am
SELECT * FROM user_all_tables WHERE TABLE_NAME LIKE UPPER('%ISSCR%') AND TABLE_NAME NOT IN (SELECT TABLE_NAME FROM user_all_tables
Comment - Like

baur b. posted an article on Baurdotnet’s Weblog - Aug 18, 2009, 12:44 am
DECLARE l_start NUMBER; l_end NUMBER; BEGIN ... l_start := dbms_utility.get_time; ... l_end := round((dbms_utility.get_time - l_start) / 100, 2); dbms_output.put_line(l_end || ' seconds...
Comment - Like

baur b. posted an article on Baurdotnet’s Weblog - Aug 18, 2009, 12:37 am
CLEAR; with t as ( select '11' num, 'string1' str, '1' DATA from dual union all select '12' num, 'string1' str, '3' DATA from dual union all select ...
Comment - Like

baur b. posted an article on Baurdotnet’s Weblog - Jul 30, 2009, 5:33 am
1st Method CLEAR; with t as ( select 'fabc iabc oabcd' fio from dual union all select ' fabc iabc oabcd' fio from dual union all select 'fabc iabc oabcd ' fio from...
Comment - Like