(Connor McDonald) Here’s a simple little PL/SQL block where we call an inner procedure PARAMETER_TESTER from its parent block.
Tag: Oracle
18c Upgrade Getting to Results – The cluster upgrade state is [NORMAL]
(mdinh) There are/were a lot of discussions about Check 18c Upgrade Results – The cluster upgrade state is [UPGRADE FINAL] on how cluvfy stage -post crsinst -allnodes -collect cluster -gi_upgrade could have changed the cluster upgrade state to [NORMAL].
Oracle Certification 12c Notes – DBA Track
(Natik Ameen) Manage Multitenant CDB and PDBs with EM Express. Quick and easy steps to create, setup and deploy EM Express.
Oracle Golden Gate Microservice Architecture Installation
(Jagruti Jasleniya) In Previous article we have seen detail of components of Oracle Golden Gate Microservice Architecture.
Update Override OPatch
(mdinh) Framework to source GI/DB RAC environment stored on shared volume.
V$SQL_CS_HISTOGRAMS: What Are the Buckets’ Thresholds?
(Christian Antognini) The contents of the V$SQL_CS_HISTOGRAM view is used by the SQL engine to decide when a cursor is made bind aware, and therefore, when it should use adaptive cursor sharing.
Oracle Golden Gate Microservice Architecture Components
(Jagruti Jasleniya) Till date we have seen all articles on Golden Gate with classic architecture and worked on golden gate software command line interface[ggsci] prompt.
Debugging PL/SQL…in APEX
(Jeff Smith) Of course you can debug your PL/SQL from SQL Developer when you start it in SQL Developer.
Using the Secure External Password store with sqlcl
(Martin Bach) Sometimes it is necessary to invoke a SQL script in bash or otherwise in an unattended way.
Quick and easy masking
(Connor McDonald) I had a request from a client a while back regarding masking of data.
