Oracle PLSQL to Generate XML Tag Using Standard Functionality
declare l_ctx dbms_xmlquery.ctxHandle; l_clob clob; begin l_ctx := dbms_xmlquery.newContext(‘select * from <TABLE_NAME>’); dbms_lob.createtemporary(:g_clob,true,d...
Read MoreDatabase
Insights and Experiences from Doyensys’ Database Administrators.
Exploring the New Security Features in Oracle Database 23ai
Oracle Database 23ai introduces advanced security features designed to enhance data protection, simplify configurations, and align with modern security standards. These updates str...
Read MoreDynamic Query Script to create public synonym and private synonym in database
Please use the below query to generate the script and run accordingly. Public Synonym: ——————– select ‘create or replace publ...
Read MoreScript to fix export issue while it hangs during Statistics, Marker, Type
Please run the below and do the export again. create index SYS.IMPDP_STATS_1 ON SYS.IMPDP_STATS (c5,type,c1,c2,c3,c4,statid,version); ...
Read MoreStep-by-Step Guide for SQL Server Always on Failover
Step-by-Step Guide for SQL Server Always on Failover Introduction SQL Server Always On Availability Groups provide high availability and disaster recovery capabi...
Read MoreEssential Guide for Regular MS SQL Server Patching
Essential Guide for Regular MS SQL Server Patching Introduction: In SQL Server management, keeping up with service packs and cumulative updates is not just aÂ...
Read More