Dissecting Oracle Database 19.11.1 vs 19.11.0

Starting this patch cycle (July-2021), I will write quarterly blog posts giving much more details about the internal changes performed by patches in Oracle internal dictionary views and files. In the past, those changes included only code changes.

Please leave in the comments if you think that anything would worth to be included.

For some other changes in this same July-2021 cycle, check the links:
Dissecting Oracle Database 19.12.0 vs 19.11.0
Dissecting Oracle Database 19.11.1 vs 19.11.0
Dissecting Oracle Database 19.10.3 vs 19.10.2

Contents

Events

Included in V_$EVENT_NAME (1)

EVENT# EVENT_ID NAME PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS DISPLAY_NAME
602 4006461557 CLSR call completion service hash id call out type call out number 1893977003 0 Other CLSR call completion

Removed from V_$EVENT_NAME (1)

EVENT# EVENT_ID NAME PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS DISPLAY_NAME
602 3032279283 CRS get service attributes service hash id p2 p3 1893977003 0 Other CRS get service attributes

Bugs fixed

Included in $ORACLE_HOME (49)

TOTAL
49

Coded objects

Included in DBA_SOURCE/DBA_VIEWS (1)

OWNER NAME TYPE
SYS SYS_YOID0000073575$ TYPE

Removed from DBA_SOURCE/DBA_VIEWS (1)

OWNER NAME TYPE
SYS SYS_YOID0000073579$ TYPE

Changed on DBA_SOURCE/DBA_VIEWS (17)

OWNER NAME TYPE COMPARE_COLUMN_NAME OLD_VALUE NEW_VALUE
MDSYS AGGRCONCAT TYPE MD5_ENC 72FFDEB9492846A03C34B5AF213AD4B7 429B54949B45D2132D956CA3358306B9
MDSYS AGGRCONCAT TYPE BODY MD5_ENC 8D0C47591EFB7514525FFDCEF70F1863 B357C142F963A2E176150E3864DE0A4B
MDSYS SDO_3GL PACKAGE BODY MD5_ENC F4FBE1DBACC6C9BC026ED668098666CB 844873DA58950E473CB7E81C38FB30CC
MDSYS SDO_GEOR PACKAGE BODY MD5_ENC 0503FBE38CDABDB5DE34AFC7840BC6CD 9C68C4052119B5DEA2128F5469641CAB
MDSYS SDO_UTIL PACKAGE BODY MD5_ENC 4838CA7772316D0DD5391EA448FAB3D5 2102FF007D5DBB93DB55C87720E7E243
SYS DBMS_BACKUP_RESTORE PACKAGE MD5_ENC 10EE58D803098994418B09EB598E157A D397FA19D40E63C0379350D7F44BD3DA
SYS DBMS_RCVMAN PACKAGE BODY MD5_ENC 5265F416D4B4877A1C8DAC0FAC3493CE B30130703E0F06FEBDDFF732A7B007B3
SYS DBMS_REGISTRY PACKAGE MD5_ENC AAC361969A327FB25A1BDF16C32C31CC 67113BC2223F808D5F5AA1E06FD1E1E1
SYS INT$DBA_JSON_DATAGUIDES VIEW MD5_ENC 2E6215BDBBA490ABE598D5291A0A4C8D 46C750E1DB221699E58EF86091D324C6
SYS IS_VPD_ENABLED FUNCTION MD5_ENC 5C0FDC2C20FB43CCEC643B4929FC863C 94EC973CBBEF419B31C3CA46573A3F78
SYS JSON_DATAGUIDE FUNCTION MD5_ENC AE7CDBED9B3C7F3259E8495AC7611D25 1ED54295B7124F397E5BD9F68763FDE6
SYS PRVT_EMX PACKAGE BODY MD5_ENC 13471BAE335120BC9153904867A34301 74AFA4AF960161081C89E6F926C529BF
SYS SYS_DGAGG FUNCTION MD5_ENC 900DEA2612717FC69ACD93EF44DE9A96 A1FD57F6F788EEF225C388DE0B669D72
SYS VALIDATE_CONTEXT PROCEDURE MD5_ENC 93DA02A40B33EF4962CD89AB60279EA8 F07516ED7C3AA51FBF6526A529E871E2
XDB DBMS_XDBZ PACKAGE BODY MD5_ENC 61A3813B8E9030D00AA9FDCD108E7BE2 41D5F7950E4920D3504E3B7EACD2A1B5
XDB DBMS_XDBZ0 PACKAGE MD5_ENC B5FE95506FD726AE912BA01D9DA543A0 13BB55E140217181FDEB7E47F5A901C1
XDB DBMS_XDBZ0 PACKAGE BODY MD5_ENC E8CD31B8F4E8BBD0BD49308C7BCCA67B 2C8AC08A8A030B10B6DA3F4574752F4C

$ORACLE_HOME non-binary files

Included in $ORACLE_HOME (5)

PATH MD5_HASH
./inventory/oneoffs/32844504/etc/config/actions.xml EAE3AD05F03C232D83E53464DB06909B
./inventory/oneoffs/32844504/etc/config/inventory.xml DFEEF0BD4642AD4CEACE5422CB31145B
./jdk/jre/legal/javafx/public_suffix.md C2D4B87600E0769171F791F64283E22D
./jdk/legal/javafx/public_suffix.md C2D4B87600E0769171F791F64283E22D
./rdbms/admin/backport_files/bug_32190284_apply.sql 660A16EDB42BF665F9676E2024969410

Removed from $ORACLE_HOME (2)

PATH MD5_HASH
./inventory/oneoffs/32545013/etc/config/actions.xml B727604E36B85B80585A20BE6FD21309
./inventory/oneoffs/32545013/etc/config/inventory.xml 5F0A83613B9DDD62DA32E6D3B6FDA352

Changed on $ORACLE_HOME (97)

PATH COMPARE_COLUMN_NAME OLD_VALUE NEW_VALUE
./ctx/admin/ctxval.sql MD5_HASH C92B3076E40DEE644B66456B81EF9AFF A738F3B430B2667F633F999267FBC99A
./ctx/admin/s1901000.sql MD5_HASH F1FD7B4AF6418AB2A006BFF481799DC3 CD8363B94BE00233DFF5AF48E98C67CB
./inventory/ContentsXML/comps.xml MD5_HASH 3E3CB869FE30F0B076684AF2479FCEF3 0E0F8F3A3F70D54AB7667CB831886799
./inventory/ContentsXML/oui-patch.xml MD5_HASH 7BEC194C3B7E801233CB10340FFC61E1 2A30DAB37F16061AE889734E6B538624
./inventory/invDetails.properties MD5_HASH 5E8FC383977DBC765B542BCBB3E61A39 E90C379020D2B2D7F9A29D64563029F6
./jdk/jre/legal/javafx/webkit.md MD5_HASH 979FF0B364144AE7752611823D7579BF BC809E54E699B9637940CD7867759ACE
./jdk/jre/legal/jdk/pkcs11cryptotoken.md MD5_HASH 300C82D64D67C9EA31509946A84F0698 5C69EBEE189E72D1B09DDBAE1237CAC5
./jdk/jre/lib/javafx.properties MD5_HASH 18B1AB00EAD4E3B944AF6A20C65D5973 F067B627CF6EB8D666CEACFE907A7C4B
./jdk/jre/lib/security/java.security MD5_HASH 529294027D7B54258DFF607987E8101A CDA16FFE3EFA64B10EEA1102FA6E3B78
./jdk/legal/javafx/webkit.md MD5_HASH 979FF0B364144AE7752611823D7579BF BC809E54E699B9637940CD7867759ACE
./jdk/legal/jdk/pkcs11cryptotoken.md MD5_HASH 300C82D64D67C9EA31509946A84F0698 5C69EBEE189E72D1B09DDBAE1237CAC5
./jdk/release MD5_HASH E7057434B7CF1AF3ABFC6991BD92362D 45CE6B7C5A6ACE289C0B4AEE949E8645
./lib/clntsh.map MD5_HASH 61E3F28A896C6D054A800FEFC3396D6C 83A2AC5445E95B4EE2E1F796CAF9371D
./md/admin/prvt3gl.plb MD5_HASH E99C31CEB68E7344EA0B84DFAC96AB22 579F45489DD3ADE84A961A4522F31124
./md/admin/prvtgr.plb MD5_HASH AF0215C7E71493DFE2DD1B770693DDC9 C1E22144EF1BE7311AD26596D9008C97
./md/admin/sdoaggrb.plb MD5_HASH 05012BD6A14084FBD2F12B26A755FB17 6B20A5009DEAD3F044B43D9E0ABBF3EB
./md/admin/sdoaggrh.sql MD5_HASH 242C34DC4388181AB18F15AD0DFDD7A0 E6B715D3EE8EAF23BAEA7B56D3DF1B51
./md/admin/sdottsmeta.sql MD5_HASH DF53209290DA4D33A539C7954778C12F 370899708E410A0E012614F40F5C4B79
./md/admin/sdoutlb.plb MD5_HASH 50E5BFA6904979C26AE78017B86469AA 915F457109B588AA8A2D8249BE70F987
./rdbms/admin/c18.sql MD5_HASH 97782533B40F5A781C7BBDC522A0F9DD 325C61865DEEC292498161C945958B13
./rdbms/admin/catappupgbeg2.sql MD5_HASH AA78F62CDF926C45C6B7C6570236CFB1 22F3AD201637080246A720A21E58EE98
./rdbms/admin/catconst.pm MD5_HASH E09DD572B9A030E7BB10AAFEA61514EB 889424D768DD14865D211944C87568D2
./rdbms/admin/catupstr.sql MD5_HASH 4B389C0607F243052EDFA274FD8D823A 72197FA32CFC5321640CFCEA221B14DA
./rdbms/admin/dbms_registry_basic.sql MD5_HASH 220B177B51613AADE95297AFFB0F1071 C26A4EB164186357616EF3C017ABEA61
./rdbms/admin/dbmsbkrs.sql MD5_HASH 4117132F3525E9223774B97A6F86A4C8 CA3EB8B1A6E0FB7272267CE0E88091C1
./rdbms/admin/dbmsjson.sql MD5_HASH A029BEA44EC80A01BD470EDFE69F6C24 3BD30FBED0D0E1E4FA752B3932422BC2
./rdbms/admin/prvtemxi.plb MD5_HASH 8B3BA03268E7707C6C62D57E2D670B75 EFEFCD6B0C6D6B8EE3F8F4DDF49F674A
./rdbms/admin/prvtrmns.plb MD5_HASH FF602EB0BAE658674DC86A80E724C4B3 40E7B66274D60FF564C90F039A6227C2
./rdbms/admin/prvtxdbz.plb MD5_HASH 93B6327EB8AE40AF1022330D04EF2924 EE85F13F87DF404EC4F26600A1BAC4CB
./rdbms/admin/prvtxdz0.plb MD5_HASH 51BFEF705ED9FCBA47DC5A355DFC8461 6D0F1D27433AF37069B5948AB44000AB
./rdbms/admin/recover.bsq MD5_HASH 7DF74D139E64FE3CC5876F2AEC2E68A3 DDBD8C8461414518936AE011AE9C9190
./rdbms/lib/env_rdbms.mk MD5_HASH 775F00589E9EFA75E56AAB42F832A26A 3E42EC3615A8C8E3DA7D4B3309E52646
./rdbms/mesg/oraus.msg MD5_HASH D8285718CDB2198266C324BFD4315145 4AE9A25BD4812D60835B6F074EF74290
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/active-report/common/html/activeReportTemplate.html MD5_HASH 0EF0C19E44738404AC3CCCC0248CD193 970CDE9D23D8EC88FC25F1C632060B9C
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/addm/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH FEACED9CB0C0464FC34D05F40B455C45 8874E20118ECBA0B13499F4E462465FC
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/addm/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 2C75F31A7DC98BB005D53A06E00C7EF5 270E8179F7D535DFB56EA8707A4598A1
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ash-analytics/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 8A9A9B5B7104631BF17646B462E96C63 0D5EB6657F81CB5BCB0991F0B9E20CC0
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ash-analytics/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 7339E959FD00AF85CD15D34AFDB78AE7 0B656FE4845755F8BC46E6C260587C93
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/blocking-sessions/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH AB9BBA0FD872B95AEE7C277185002A88 EC9099E0C6E926FD0F65D2FDD9641CEF
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/blocking-sessions/omx-ui-version/js/bundles/utilBundle.js MD5_HASH D87DBEBBA85268249D36632E6E6CDB41 B3A6174EA8B4B5A298208926EA66DD81
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/html/dbhome-omx.html MD5_HASH 0B952C9311E97D0D3236BFAE163620F3 F7C0D675741D213EBF74A87B77463A87
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 77AE77CC3FFFB9B86ED3474D1046CAAB B9B0BF72AD5D7541F04DE6814339D2D7
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/omx-ui-version/js/bundles/utilBundle.js MD5_HASH A1A6C16E0C355707D082AB578FEC3269 10F281B08AB322F041BD81CB4350740E
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/dbhome/omx-ui-version/js/viewmodel/dbhome.js MD5_HASH 148C65B4A1B3C1306C47BD901692F207 48C9EA443BF6BE99708A9147A7426D6B
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/html/performance-hub-omx.html MD5_HASH D097B283F815B1C932E7CCCEFD5C60D8 5E5C0F2FB5525F8FED62E22D66F17835
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 467DF00363B45B32CEF1AAE9C5CB657F F464EB5BEA89E65CADE2CA2BA7159839
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/omx-ui-version/js/bundles/utilBundle.js MD5_HASH CACE5A3FF4E0AA0AA9F0212826D9D4DB 028947FA0FD34BA3B88ADA2950D78EC5
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/performance-hub/omx-ui-version/js/viewmodel/performance-hub.js MD5_HASH 818D0E33CC74A0C686EB251BAC7AFB32 78CDAE7E83BB29969C5A76B0C81C34C3
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 7911AFDF2C59D0E8144FD779C833F8F8 090072DC0626411E94369A2E98876D11
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/bundles/utilBundle.js MD5_HASH AE2668A2015E36A92A62A87530803C47 BEB086290E848702F89D9F6AE98CEFBF
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/session-details/omx-ui-version/js/viewmodel/session-details.js MD5_HASH 964FDDE3DC8AF566B9928433FF433347 7A0C13026DBB91E3A8C5C386DAC854B1
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/html/spa-home-omx.html MD5_HASH FC54A80D847571D6F009D553F5BB50D0 231293743980709AF7274FAAD5870185
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH DA552C71217A6401E93A78B8529E34C5 10A1AB4BE971A9943E00A1BA0339F04C
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 7779CED1098160D205A7DB4EB079131E 1198824D234A83BD161FC000C1E413A5
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/spa-home/omx-ui-version/js/viewmodel/spa-home.js MD5_HASH 33365377DE41B6EA818612CE03194210 E7B9812FAC527D3A81B4C40B6185C876
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 26ECD59806C2460BF24DFD8B4BD44ED8 011DC5215548D8CC16F00DFA8660624F
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 33C426F740A47E4429AB9C96CD387179 48D65FC7B3A0A3284CDFBA6900FB26FE
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-detail/omx-ui-version/js/viewmodel/sql-detail.js MD5_HASH D26868997D353457AF9F93178AA58253 0406C56B45595CE805DB3769ED651C50
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-monitor/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 092FD718ECC90CA7BC4FCE1ADF29080A F65A194047770CA6409B2FC9ED2CFBEA
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-monitor/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 553EC50A9B45FE4B1F39A9B3C04E5AC9 CCF045F0BCD6AE55B808528A98FA5176
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/html/spa-report-omx.html MD5_HASH 8E78B3DFFAAFA6BD9A2D1EC271A6EAA0 CAE7B2FD1E862B6DF8E12C4D3463880C
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH F2A84561C5A9704E0410D90F0CBD88DB 232B454F42306AC088A8868399EB58C5
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 0DD29FAF0E5DF44268BFE78D2FB4338E 3ECAF05A5B65F2D35E750DAB74ADB399
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/sql-perf-analyzer/omx-ui-version/js/viewmodel/spa-report.js MD5_HASH 22BC552DBD8C7C3F23AD5BD53E9CDB0A A8D96949BACC9C2EA97BB067A617CAD7
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/html/tablespace-omx.html MD5_HASH 82D8271CE16A9EB384AA7D6A863420CD 5BE6C6BBC9B0C38BC80E6FF587889C36
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH A8B0F4B02BE14022F78518E6F6BAF58C 22F62C791C49019D0259616A9E0D854D
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 6637FBC16F85FFA5E866819AFE46DEB6 4BF6003A833FC8EF132E05E33C7BB1CF
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/tablespace/omx-ui-version/js/viewmodel/tablespace.js MD5_HASH 2E53E904B4F0C983EE29E79B74BC0FB8 B5425FF0E6DEF47C3A479236553E92CF
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/dbcsComponentsBundle.js MD5_HASH 60BD7DF63C701DC40A11FE18B50314BD A3F8E93C328D556080F0F33CAF8CAF39
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-3rdpartybundle.js MD5_HASH 5ABFAF1FEEE18BB5FBDB900770450A10 A5DADCA4ED370622ABC61A68102F2065
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-chartbundle.js MD5_HASH 8A91157114B33C11785745D4F4CC6FAA 55046840A1B3CA66573E0039D779DC2D
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-collectionsbundle.js MD5_HASH BCC15CBC210639648BFB452E23B63317 153376F48F447126C77E63F75143FE90
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-commoncomponentsbundle.js MD5_HASH A51DAF39B819BE3C8E068563E35C5168 9CC12734DD5C82DAD362AA9002998FF7
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-corebundle.js MD5_HASH A9B6D72B21FD56947C342D95E9C16B47 B6965659C76B381CF84290303DA2455F
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/bundles/v8.3.0/jet-dvtbasebundle.js MD5_HASH DFAD2E10A4ABBFA897FEE5917F126C6C 6BA3C916DE5DDE9D4E83748864977A91
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/util/OMXUtil.js MD5_HASH 0CD0CE0D2B0CD13C1A257DD0408554F4 4CAB9D41D5312A9B27A9F0F5CF79906E
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/util/main-config.js MD5_HASH 311178482302263A5F42D6ABA9195AAE ED6B479604FCCB0B3393E8140F74E62B
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/util/message-util/omx/MessageUtilOMX.js MD5_HASH 2FFA41CE1726153B5F05D3EC272B4C8F 5E042CCDB1FAFA1DC666FC07BB017436
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/common/omx-ui-version/js/util/omxInit.js MD5_HASH 5C7D7F6DAAAB88D6D55BA73A8173B591 3EABB5ADCD9F342F7DEABF6B5A2A1842
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/components/sql-plan-component/js/sql-plan-datagrid.js MD5_HASH 74501475E080C3F70083B1C5FD81E8A5 8255A3F43324EF1ECDCDF3EC80EFC97B
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/css/dbcsperf-all.css MD5_HASH 4C80768C25EFBB47FB53066940228747 C7255EA565B3B8969661AA2958D7BAB4
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/css/uifwk-common-alta.css MD5_HASH FB76DF7A979DE8D0EF186AD5F9804C31 4830429451A63473011EE076C0C29D24
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/bundles/commonBundle.js MD5_HASH D36F34711ADEFC261B9D7464C2A31A21 113F4AD9C5EA899A6C04D38933BA90DB
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/bundles/uiUtilsComponentsBundle.js MD5_HASH 567BC03C9C05D55844D2D9879BD731A0 1FA18AB9CBE9980CFBD1FE8BB1BB98BE
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/dbcsPerfUiMsg.js MD5_HASH 7F423D0A8147C8D27426FE9AC11C97B1 765EFCDAF7D1499429F04C23B426DCEF
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/de/dbcsPerfUiMsg.js MD5_HASH 984232DAE9CD8C6FC8C216836E95A616 CA63D4DF4A7F67865F8E6B84723B1C78
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/es/dbcsPerfUiMsg.js MD5_HASH 984232DAE9CD8C6FC8C216836E95A616 CA63D4DF4A7F67865F8E6B84723B1C78
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/fr/dbcsPerfUiMsg.js MD5_HASH A011836080D49F6B575686A3D811FDC6 5EFC5D6488C58F996FFA005B92BEE19F
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/it/dbcsPerfUiMsg.js MD5_HASH 984232DAE9CD8C6FC8C216836E95A616 CA63D4DF4A7F67865F8E6B84723B1C78
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/ja/dbcsPerfUiMsg.js MD5_HASH D4180D277D3C2294EE04E8566B1F1D78 1F2E7E4D0D9E599BBB35246A39060498
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/ko/dbcsPerfUiMsg.js MD5_HASH A94C99CB94538707AA81BABCEA88255A 2C5B18B1A985B61171581817CBF5563E
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/pt/dbcsPerfUiMsg.js MD5_HASH 984232DAE9CD8C6FC8C216836E95A616 CA63D4DF4A7F67865F8E6B84723B1C78
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/root/dbcsPerfUiMsg.js MD5_HASH 4C7BA06744A0C3033E77F1C9A8D2BEAD CE7DAB0ABE6AD0AC79574C8D3CA6F009
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/zh-Hans/dbcsPerfUiMsg.js MD5_HASH 2E578B14033D5E44484556EDFAC11612 158F4F920E6013290C92EDA17BEC331F
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/ui-utils/omx-ui-version/js/resources/nls/zh-Hant/dbcsPerfUiMsg.js MD5_HASH 96016C486B2D5F57460CFF794F0DD491 0B02B9E6D358EFEBFC918E9897D7DA59
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/workload/omx-ui-version/js/bundles/componentsBundle.js MD5_HASH 76B4AFE822E5A16E46F191DC28A9934F 6DE5A887D3865DF9F9016DDF1678989F
./rdbms/xml/em/emsaasui/emcdbms-dbcsperf/workload/omx-ui-version/js/bundles/utilBundle.js MD5_HASH 6BBF0687D75A101E26C12E614697892C 79C4AE43B9FF6C09040A4AB4768137E3

Table privileges

Removed from DBA_TAB_PRIVS (1)

GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRANTABLE HIERARCHY COMMON TYPE INHERITED
CTXSYS SYS VALIDATE_CONTEXT SYS EXECUTE NO NO YES PROCEDURE NO

Changes in Coded Objects (17)

MDSYS.AGGRCONCAT - TYPE:
     3	  context mdsys.SDOAggr,                              |   -- context mdsys.SDOAggr,
     5	  -- context raw(4),                                  |   -- bug 31844560: sdo_aggr_concat_line with group by
     6	                                                      >   context raw(4),

MDSYS.AGGRCONCAT - TYPE BODY:
     4	 RETURN NUMBER IS                                                             |  RETURN NUMBER
     5	   ENABLED VARCHAR2(5);                                                       <
     6	 BEGIN                                                                        <
     7	   IF ( SDO_UTIL.IS_SPATIAL_ENABLED() ) THEN                                  <
     8	     ENABLED := 'YES';                                                        <
     9	   ELSE                                                                       <
    10	     ENABLED := 'NO';                                                         <
    11	   END IF;                                                                    <
    12	   MDSYS.MDPRVT_FEATURE.SDO_REGISTER_FEATURE('AGGREGATES', ENABLED);          <
    13	                                                                              <
    14	   SCTX := AGGRCONCAT(MDSYS.SDOAGGR(NULL, NULL, 0, 'SDO_CONCAT', NULL,NULL)); <
    15	   RETURN ODCICONST.SUCCESS;                                                  <
    16	 END;                                                                         <
    19	                                                                              >    AS LANGUAGE C
    20	                                                                              >     LIBRARY ORDMD_AG_LIBS
    21	                                                                              >     NAME "mdconcinit"
    22	                                                                              >     WITH CONTEXT
    24	                                                                              >        CONTEXT,
    25	                                                                              >        SCTX,
    26	                                                                              >        SCTX INDICATOR STRUCT,
    27	                                                                              >        RETURN OCINUMBER );
    39	 MEMBER FUNCTION ODCIAGGREGATEITERATE(SELF IN OUT AGGRCONCAT,                 <
    40	    GEOM IN MDSYS.SDO_GEOMETRY)                                               <
    41	   RETURN NUMBER IS                                                           <
    42	   BEGIN                                                                      <
    43	     RETURN CONTEXT.ODCIAGGREGATEITERATE(MDSYS.SDOAGGRTYPE(GEOM,NULL));       <
    44	   END;                                                                       <
    45	                                                                              <
    46	                                                                              <
    47	                                                                              <
    52	                                                                              >  MEMBER FUNCTION ODCIAGGREGATEITERATE(SELF IN OUT AGGRCONCAT,
    53	                                                                              >     GEOM IN MDSYS.SDO_GEOMETRY)
    54	                                                                              >  RETURN NUMBER
    57	                                                                              >     AS LANGUAGE C
    58	                                                                              >     LIBRARY ORDMD_AG_LIBS
    59	                                                                              >     NAME "mdconciter"
    60	                                                                              >     WITH CONTEXT
    62	                                                                              >       CONTEXT,
    63	                                                                              >       SELF,
    64	                                                                              >       SELF INDICATOR STRUCT,
    65	                                                                              >       GEOM,
    66	                                                                              >       GEOM INDICATOR STRUCT,
    67	                                                                              >       RETURN OCINUMBER);
    77	  RETURN NUMBER IS                                                            |  RETURN NUMBER
    78	  BEGIN                                                                       <
    79	     RETURNVALUE := CONTEXT.GEOMETRY;                                         <
    80	     RETURN ODCICONST.SUCCESS;                                                <
    81	   END;                                                                       <
    82	                                                                              <
    83	                                                                              <
    84	                                                                              <
    85	                                                                              <
    86	                                                                              <
    87	                                                                              <
    88	                                                                              <
    89	                                                                              <
    92	                                                                              >     AS LANGUAGE C
    93	                                                                              >     LIBRARY ORDMD_AG_LIBS
    94	                                                                              >     NAME "mdconcterm"
    95	                                                                              >     WITH CONTEXT
    97	                                                                              >       CONTEXT,
    98	                                                                              >       SELF,
    99	                                                                              >       SELF INDICATOR STRUCT,
   100	                                                                              >       RETURNVALUE,
   101	                                                                              >       RETURNVALUE INDICATOR STRUCT,
   102	                                                                              >       FLAGS,
   103	                                                                              >       FLAGS INDICATOR,
   104	                                                                              >       RETURN OCINUMBER);
   114	   RETURN NUMBER IS                                                           |  RETURN NUMBER
   115	   BEGIN                                                                      <
   116	     RETURN CONTEXT.ODCIAGGREGATEMERGE(SCTX2.CONTEXT);                        <
   117	   END;                                                                       <
   118	                                                                              <
   119	                                                                              <
   120	                                                                              <
   121	                                                                              <
   122	                                                                              <
   123	                                                                              <
   126	                                                                              >     AS LANGUAGE C
   127	                                                                              >     LIBRARY ORDMD_AG_LIBS
   128	                                                                              >     NAME "mdconcmerg"
   129	                                                                              >     WITH CONTEXT
   131	                                                                              >       CONTEXT,
   132	                                                                              >       SELF,
   133	                                                                              >       SELF INDICATOR STRUCT,
   134	                                                                              >       SCTX2,
   135	                                                                              >       SCTX2 INDICATOR STRUCT,
   136	                                                                              >       RETURN OCINUMBER);

MDSYS.SDO_3GL - PACKAGE BODY:
  2055	       GEOM2 := GEOM_OPERATION_INT(DIM2,GEOM,10,DIM2,GEOM);                  |        GEOM2 := MDSYS.SDO_UTIL.RECTIFY_GEOMETRY(GEOM, DIM(1).SDO_TOLERANCE);
  2535	                                                                             >     GEOM2   MDSYS.SDO_GEOMETRY;
  2536	                                                                             >     VAR1    NUMBER;
  2540	    RETURN GEOM_OPERATION_INT(DIMOBJ, GEOM1, 10, DIMOBJ, GEOM1);             |     VAR1 := MDSYS.SDO_3GL.GET_EVENT(54677);
  2541	                                                                             |     MDSYS.SDO_3GL.SET_EVENT(54677, (VAR1+64));
  2542	                                                                             >     GEOM2 := GEOM_OPERATION_INT(DIMOBJ, GEOM1, 10, DIMOBJ, GEOM1);
  2543	                                                                             >     MDSYS.SDO_3GL.SET_EVENT(54677, VAR1);
  2544	                                                                             >     RETURN GEOM2;

MDSYS.SDO_GEOR - PACKAGE BODY:
  6653	        IF((MMM_VALUE*2>MM_PIX)AND(MMM_MEDIAN=-32769))  |         IF((MMM_VALUE*2>=MM_PIX)AND(MMM_MEDIAN=-32769))
  6662	                                                        >       MMM_MODE:= MMM_MODE-128;
  6666	                                                        >       MMM_MODE:= MMM_MODE-32768;

MDSYS.SDO_UTIL - PACKAGE BODY:
  5106	 FUNCTION INTERIOR_POINT (GEOM MDSYS.SDO_GEOMETRY, TOL NUMBER := 0.00000000005)      |  FUNCTION INTERIOR_POINT(GEOM MDSYS.SDO_GEOMETRY,
  5107	                                                                                     >                          TOL NUMBER := 0.00000000005)
  5113	                                                                                     >    SDO_FULL RAW(255);
  5114	                                                                                     >    LEN_1 BINARY_INTEGER;
  5115	                                                                                     >    LEN_2 BINARY_INTEGER;
  5130	 LGEOM MDSYS.SDO_GEOMETRY;                                                           |    LINE_GEOM MDSYS.SDO_GEOMETRY;
  5132	 NGEOM MDSYS.SDO_GEOMETRY;                                                           |    TILE_CENTER MDSYS.SDO_GEOMETRY;
  5134	 CGEOM MDSYS.SDO_GEOMETRY;                                                           |    CENTER_POINT MDSYS.SDO_GEOMETRY;
  5135	                                                                                     >    RGEOM_SET_TO_CENTER BOOLEAN;
  5144	         ITOL := TOL/100000;                                                         |        ITOL := ITOL/100000;
  5150	                                                                                     >    IF ( G.SDO_ORDINATES.COUNT < 4 ) THEN
  5151	                                                                                     >      MDERR.RAISE_MD_ERROR('MD', 'SDO', -13199,
  5152	                                                                                     >                           'Insufficient number of ordinate values');
  5153	                                                                                     >      RETURN NULL;
  5154	                                                                                     >    END IF;
  5155	                                                                                     >
  5161	                                                                                     >    G := NULL;
  5162	                                                                                     >
  5168	     CGEOM := MDSYS.SDO_GEOMETRY(2001, GEOM.SDO_SRID,                                |
  5169	                MDSYS.SDO_POINT_TYPE((BX1+BX2)/2., (BY1+BY2)/2., NULL), NULL, NULL); |    RGEOM_SET_TO_CENTER := FALSE;
  5170	     LGEOM := SDO_UTIL.POLYGONTOLINE(GEOM);                                          |    CENTER_POINT := MDSYS.SDO_GEOMETRY(2001,
  5171	                                                                                     >                                       GEOM.SDO_SRID,
  5173	                                                                                     >                                         (BX1+BX2)/2.0,
  5174	                                                                                     >                                         (BY1+BY2)/2.0,
  5175	                                                                                     >                                         NULL),
  5176	                                                                                     >                                       NULL,
  5177	                                                                                     >                                       NULL);
  5178	                                                                                     >    LINE_GEOM := SDO_UTIL.POLYGONTOLINE(GEOM);
  5179	                                                                                     >
  5190	     FOR SDO_LVL  IN 3 ..10  LOOP                                                    |    FOR SDO_LVL IN 3 .. 15
  5191	                                                                                     >    LOOP
  5193	       FOR IDX IN 1 .. FIX_TILES.COUNT LOOP                                          |
  5194	                                                                                     >      FOR IDX IN 1 .. FIX_TILES.COUNT
  5195	                                                                                     >      LOOP
  5200	            X1 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 1, BX1, BX2,             |          SDO_FULL := FIX_TILE.SDO_CODE||SDO_META;
  5201	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 1), 'MIN'));                        |          LEN_1 := MDSYS.HHLENGTH(SDO_FULL, 1);
  5202	            Y1 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 2, BY1, BY2,             |          LEN_2 := MDSYS.HHLENGTH(SDO_FULL, 2);
  5203	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 2), 'MIN'));                        |
  5204	                                                                                     |          X1 := MDSYS.HHCELLBNDRY(SDO_FULL, 1, BX1, BX2, LEN_1, 'MIN');
  5205	            X2 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 1, BX1, BX2,             |          Y1 := MDSYS.HHCELLBNDRY(SDO_FULL, 2, BY1, BY2, LEN_2, 'MIN');
  5206	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 1), 'MAX'));                        |
  5207	            Y2 := (HHCELLBNDRY(FIX_TILE.SDO_CODE||SDO_META, 2, BY1, BY2,             |          X2 := MDSYS.HHCELLBNDRY(SDO_FULL, 1, BX1, BX2, LEN_1, 'MAX');
  5208	           HHLENGTH(FIX_TILE.SDO_CODE||SDO_META, 2), 'MAX'));                        |          Y2 := MDSYS.HHCELLBNDRY(SDO_FULL, 2, BY1, BY2, LEN_2, 'MAX');
  5209	                                                                                     |
  5210	                                                                                     |
  5211	          IF ((CGEOM.SDO_POINT.X > X1) AND (CGEOM.SDO_POINT.X < X2) AND              |          IF ((NOT RGEOM_SET_TO_CENTER) AND
  5212	              (CGEOM.SDO_POINT.Y > Y1) AND (CGEOM.SDO_POINT.Y < Y2)) THEN            |              (CENTER_POINT.SDO_POINT.X > X1) AND
  5213	            NDIST := 10;                                                             |              (CENTER_POINT.SDO_POINT.X < X2) AND
  5214	            RGEOM := CGEOM;                                                          |              (CENTER_POINT.SDO_POINT.Y > Y1) AND
  5215	                                                                                     >              (CENTER_POINT.SDO_POINT.Y < Y2)) THEN
  5216	                                                                                     >            RGEOM := CENTER_POINT;
  5217	                                                                                     >            RGEOM_SET_TO_CENTER := TRUE;
  5221	                                                                                     >          TILE_CENTER := MDSYS.SDO_GEOMETRY(2001,
  5222	                                                                                     >                                            GEOM.SDO_SRID,
  5224	                                                                                     >                                              (X1+X2)/2.0,
  5225	                                                                                     >                                              (Y1+Y2)/2.0,
  5226	                                                                                     >                                              NULL),
  5227	                                                                                     >                                            NULL,
  5228	                                                                                     >                                            NULL);
  5230	           NGEOM := MDSYS.SDO_GEOMETRY(2001, GEOM.SDO_SRID,                          |          NDIST := SDO_GEOM.SDO_DISTANCE(TILE_CENTER, LINE_GEOM, ITOL);
  5231	                MDSYS.SDO_POINT_TYPE((X1+X2)/2., (Y1+Y2)/2., NULL), NULL, NULL);     <
  5232	           NDIST := SDO_GEOM.SDO_DISTANCE(NGEOM, LGEOM, ITOL);                       <
  5234	              RGEOM := NGEOM;                                                        |            RGEOM := TILE_CENTER;
  5235	                                                                                     >            RGEOM_SET_TO_CENTER := FALSE;
  5238	                                                                                     >          TILE_CENTER := NULL;

SYS.DBMS_BACKUP_RESTORE - PACKAGE:
    12	  bannerVersion CONSTANT VARCHAR2(15) := '19.11.00.00';                  |   bannerVersion CONSTANT VARCHAR2(15) := '19.11.01.00';
    24	  fsn  CONSTANT NUMBER := instr('19.11.00.00', '.');                     |   fsn  CONSTANT NUMBER := instr('19.11.01.00', '.');
    25	  msn  CONSTANT NUMBER := instr('19.11.00.00', '.', fsn + 1);            |   msn  CONSTANT NUMBER := instr('19.11.01.00', '.', fsn + 1);
    26	  psn  CONSTANT NUMBER := instr('19.11.00.00', '.', msn + 1);            |   psn  CONSTANT NUMBER := instr('19.11.01.00', '.', msn + 1);
    29	                           to_number(substr('19.11.00.00', 1, fsn - 1)); |                            to_number(substr('19.11.01.00', 1, fsn - 1));
    31	               to_number(substr('19.11.00.00', fsn + 1, msn - fsn - 1)); |                to_number(substr('19.11.01.00', fsn + 1, msn - fsn - 1));
    33	              to_number(substr('19.11.00.00',  msn + 1, psn - msn - 1)); |               to_number(substr('19.11.01.00',  msn + 1, psn - msn - 1));
    35	                             to_number(substr('19.11.00.00',  psn + 1)); |                              to_number(substr('19.11.01.00',  psn + 1));

SYS.DBMS_RCVMAN - PACKAGE BODY:
   122	CATALOGVERSION CONSTANT VARCHAR2(11) := '19.11.00.00'; | CATALOGVERSION CONSTANT VARCHAR2(11) := '19.11.01.00';
SYS.DBMS_REGISTRY - PACKAGE:
    13	                               '19.11.0.0.0'; |                                '19.11.1.0.0';
SYS.INT$DBA_JSON_DATAGUIDES - VIEW:
     7	           dbms_json.format_flat, dbms_json.pretty) "DATAGUIDE"          |            xdb.dbms_json.format_flat, xdb.dbms_json.pretty) "DATAGUIDE"
    33	           dbms_json.format_flat, dbms_json.pretty)  "DATAGUIDE"         |            xdb.dbms_json.format_flat, xdb.dbms_json.pretty)  "DATAGUIDE"

SYS.IS_VPD_ENABLED - FUNCTION:
     4	                                          DBMS_XDBZ.IS_ENABLED_CONTENTS)     |                                           XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS)
    16	   IF (HIERARCHY_TYPE = DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN                  |    IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN

SYS.JSON_DATAGUIDE - FUNCTION:
     2	                           format NUMBER DEFAULT DBMS_JSON.FORMAT_FLAT,     |                            format NUMBER DEFAULT XDB.DBMS_JSON.FORMAT_FLAT,
SYS.PRVT_EMX - PACKAGE BODY:
    20	  OMX_VERSION           CONSTANT VARCHAR2(20) := '1.51.0-200917.184935'; |   OMX_VERSION           CONSTANT VARCHAR2(20) := '1.54.0-210504.174846';
SYS.SYS_DGAGG - FUNCTION:
     2	                            format NUMBER DEFAULT DBMS_JSON.FORMAT_FLAT,     |                             format NUMBER DEFAULT XDB.DBMS_JSON.FORMAT_FLAT,
SYS.VALIDATE_CONTEXT - PROCEDURE:
   113	    ctxsys.drue.text_on_stack(sqlerrm, 'validate_context'); <
   115	    ctxsys.drue.raise;                                      |   raise_application_error(-20000,
   116	                                                            >     'Oracle Text error:' || '
   117	                                                            > ' || 'DRG-50857: oracle error in validate_context' || '
   118	                                                            > ' || sqlerrm || '
   119	                                                            > ' );

XDB.DBMS_XDBZ - PACKAGE BODY:
    72	                                                   HIERARCHY_TYPE);                |                               OBJECT_SCHEMA, OBJECT_NAME, HIERARCHY_TYPE);
XDB.DBMS_XDBZ0 - PACKAGE:
   129	                                    DBMS_XDBZ.ENABLE_CONTENTS,            |                                     XDB.DBMS_XDBZ.ENABLE_CONTENTS,
   145	                                        := DBMS_XDBZ.DISABLE_ALL,         |                                         := XDB.DBMS_XDBZ.DISABLE_ALL,
   153	                                       DBMS_XDBZ.IS_ENABLED_CONTENTS)     |                                        XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS)

XDB.DBMS_XDBZ0 - PACKAGE BODY:
   263	   HIERARCHY_TYPE IN PLS_INTEGER := DBMS_XDBZ.ENABLE_CONTENTS,                  |    HIERARCHY_TYPE IN PLS_INTEGER := XDB.DBMS_XDBZ.ENABLE_CONTENTS,
   332	                                     DBMS_XDBZ.IS_ENABLED_VERSION);             |                                      XDB.DBMS_XDBZ.IS_ENABLED_VERSION);
   340	                                            DBMS_XDBZ.IS_ENABLED_CONTENTS);     |                                             XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS);
   348	                                    DBMS_XDBZ.DISABLE_ALL, FALSE);              |                                     XDB.DBMS_XDBZ.DISABLE_ALL, FALSE);
   361	                                    DBMS_XDBZ.DISABLE_ALL, FALSE);              |                                     XDB.DBMS_XDBZ.DISABLE_ALL, FALSE);
   644	                                        := DBMS_XDBZ.DISABLE_ALL,               |                                         := XDB.DBMS_XDBZ.DISABLE_ALL,
   714	       HIERARCHY_TYPE = DBMS_XDBZ.DISABLE_ALL) THEN                             |        HIERARCHY_TYPE = XDB.DBMS_XDBZ.DISABLE_ALL) THEN
   733	     IF (HIERARCHY_TYPE = DBMS_XDBZ.DISABLE_ALL) THEN                           |      IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.DISABLE_ALL) THEN
   753	   IF (HIERARCHY_TYPE = DBMS_XDBZ.DISABLE_ALL) THEN                             |    IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.DISABLE_ALL) THEN
   858	                                       DBMS_XDBZ.IS_ENABLED_CONTENTS)           |                                        XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS)
   878	   IF (BITAND(HIERARCHY_TYPE, DBMS_XDBZ.IS_ENABLED_VERSION) =                   |    IF (BITAND(HIERARCHY_TYPE, XDB.DBMS_XDBZ.IS_ENABLED_VERSION) =
   879	              DBMS_XDBZ.IS_ENABLED_VERSION) THEN                                |               XDB.DBMS_XDBZ.IS_ENABLED_VERSION) THEN
   903	   IF (HIERARCHY_TYPE = DBMS_XDBZ.IS_ENABLED_VERSION) THEN                      |    IF (HIERARCHY_TYPE = XDB.DBMS_XDBZ.IS_ENABLED_VERSION) THEN
   907	   IF (BITAND(HIERARCHY_TYPE, DBMS_XDBZ.IS_ENABLED_CONTENTS) =                  |    IF (BITAND(HIERARCHY_TYPE, XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS) =
   908	              DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN                               |               XDB.DBMS_XDBZ.IS_ENABLED_CONTENTS) THEN

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.