The following case just want to share it in case anyone need it, development wants to import the existing table in the siebel schema into the new name to check the data integrity: Oracle Provide you w...
En Oracle Application Express 5.1, los asistentes se han simplificado con valores predeterminados más inteligentes y con menos pasos, lo que permite a los desarrolladores crear componentes más rápidam...
Docker container has revolutionized the use of software with its modularity, platform independence, efficient use of resources, and fast installation time. Docker lends itself to the DevOps approach t...
NOTE: This article was written using Oracle Public Cloud. Introduction: Developers and end users are the roles that mostly use the database. Developers keep fixing code, maintaining the legacy applic...
If you have been in my tuning class or read my tuning blogs, I carry on at length about the importance of reviewing the explain plan with which the SQL executed, not an explain plan because you needed...
We continue this series of blogs on New Features for Developers with some updated conditional compilation features. Oracle10 introduced conditional compilation, or the ability to compile PL/SQL lines...
For those Toad for Oracle users that often execute long running queries using F9, they always ask me how they can still work in Toad without having to wait on the query to finish. The problem seems to...
We know very much about the backup of databases and restoring the database in same server or different server, but when it comes to catalog database to manage global data services the procedure is ent...
Hi, We continue this series of blogs on New Features for Developers with some updated conditional compilation features. This feature allows for you to get rid of the upper and lower functions when com...
This article is focused on how to do troubleshoot the Logical standby database and monitoring the logical standby database apply, In detail we will go through how the SQL Apply process actually works ...
Hi, We continue this series of blogs on New Features for Developers with some updated syntax to external tables. External tables are great and they have been around for a while. They are basically a ...
Hi, I’ll start this series of blogs on New Features for Developers. The first is quick but good! A while back, December of 2014 to be exact, I blogged about APPROX_COUNT and how much faster it was. T...
