Differences

This shows you the differences between two versions of the page.

--- dba:oracle:basic_oracle_sql_querys [2023/07/03 08:22] – [Virtual columns] dodger
+++ dba:oracle:basic_oracle_sql_querys [2023/07/03 08:24] – [NOT owned by oracle] dodger
@@ Line 1: / Line 1: @@
 ====== [DOC] Oracle basic queries ======
+====== [SECTION] PRE-basics ======
+===== NOT owned by oracle =====
+This is really useful to remove "noise" on queries:
+<code sql>
+and NOT owner in (
+       'SYSTEM','CTXSYS','DBSNMP','EXFSYS','LBACSYS','MDSYS','MGMT_VIEW',
+       'OLAPSYS','ORDDATA','OWBSYS','ORDPLUGINS','ORDSYS','OUTLN',
+       'SI_INFORMTN_SCHEMA','SYS','SYSMAN','WK_TEST','WKSYS','WKPROXY',
+       'WMSYS','XDB','APEX_PUBLIC_USER','DIP','FLOWS_020100','FLOWS_030000',
+       'FLOWS_040100','FLOWS_010600','FLOWS_FILES','MDDATA','ORACLE_OCM',
+       'SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','XS$NULL','PERFSTAT',
+       'SQLTXPLAIN','DMSYS','TSMSYS','WKSYS','APEX_040000','APEX_040200',
+       'DVSYS','OJVMSYS','GSMADMIN_INTERNAL','APPQOSSYS','DVSYS','DVF',
+       'AUDSYS','APEX_030200','MGMT_VIEW','ODM','ODM_MTR','TRACESRV','MTMSYS',
+       'OWBSYS_AUDIT','WEBSYS','WK_PROXY','OSE$HTTP$ADMIN',
+       'AURORA$JIS$UTILITY$','AURORA$ORB$UNAUTHENTICATED',
+       'DBMS_PRIVILEGE_CAPTURE','CSMIG','MGDSYS','SDE','DBSFWUSER'
+    )
+</code>