Oracle streams implementation at schema level

conn sys/password@dba1 as sysdbacreate tablespace demo_TS datafile 'E:\TestDB\oradata\DBA1\demo_DAT.dbf' size 50M autoextend off extent management local;create user demo IDENTIFIED BY demo DEFAULT TABLESPACE demo_TS TEMPORARY TABLESPACE TEMP;ALTER USER demo QUOTA UNLIMITED on demo_TS;grant connect to demo;conn sys/password@dba2 as sysdbacreate tablespace demo_TS datafile 'E:\TestDB\oradata\DBA2\demo_DAT.dbf' size 50M autoextend off extent management local;create user demo IDENTIFIED BY demo DEFAULT TABLESPACE demo_TS TEMPORARY TABLESPACE TEMP;ALTER...

Read More

GROUP BY queries and the equivalent GROUPING SET queries

Records in the table: SQL> select * from Grouping_tbl;A B AMT-- --- ----------10 101 5510 102 7520 8001 3520 8002 4510 101 2520 8001 256 rows selected. Script 1: SQL> SELECT a, b, SUM(amt) FROM Grouping_tbl GROUP BY a, b;A B SUM(AMT)--- ----- ------10 101 8010 102 7520 8001 6020 8002 45SQL> SELECT a, b, SUM(amt) FROM Grouping_tbl GROUP BY GROUPING SETS ( (a,b) );A B SUM(AMT)--- ----- ------10 101 8010 102 7520 8001 6020 8002 45 Script 2: SQL> SELECT a, b, SUM( amt ) FROM Grouping_tbl GROUP BY a, b2 UNION3 SELECT a, null, SUM( amt...

Read More