Oracle optimizer removing or coalescing subqueries
The post Oracle optimizer removing or coalescing subqueries appeared first on SQLServerCentral.
Oracle
Why your PL/SQL needs to be testable – and how ...
The post Why your PL/SQL needs to be testable – and how to do it: Part 1 appeared […]
Oracle subquery caching and subquery pushing
The post Oracle subquery caching and subquery pushing appeared first on SQLServerCentral.
The effects of NULL with NOT IN on Oracle transformations
The post The effects of NULL with NOT IN on Oracle transformations appeared first on SQLServerCentral.
Oracle ASM: Migrating from UDEV devices to the ASM Filter ...
I recently had a client express some interest in migrating from UDEV managed devices in Oracle ASM to […]
Running SQL Server on Oracle and Google Cloud
Introduction In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure (OCI) and Google […]
Transformations by the Oracle Optimizer
The post Transformations by the Oracle Optimizer appeared first on SQLServerCentral.
Install SQL Server and Oracle using PowerShell and Windows Containers
The post Install SQL Server and Oracle using PowerShell and Windows Containers appeared first on SQLServerCentral.
Oracle sequences – 12c features including “identity”
The post Oracle sequences – 12c features including “identity” appeared first on SQLServerCentral.
Text Mining and Sentiment Analysis: Oracle Text
The series so far: Text Mining and Sentiment Analysis: Introduction Text Mining and Sentiment Analysis: Power BI […]
SQL VIEW Comparison in SQL Server, Oracle and PostgreSQL
The post SQL VIEW Comparison in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.
Typical uses of Oracle sequences
The post Typical uses of Oracle sequences appeared first on SQLServerCentral.
Oracle Sequences: RAC
The series so far: Oracle sequences: The basics Oracle sequences: RAC In my first article on Sequences, […]
SQL Window Functions in SQL Server, Oracle and PostgreSQL
The post SQL Window Functions in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.
Oracle sequences: The basics
Many database applications make use of “meaningless ids” or “synthetic keys” rather than using columns of user […]
Delete SQL Statement in SQL Server, Oracle and PostgreSQL
The post Delete SQL Statement in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.
SQL Update Statement with Join in SQL Server vs Oracle ...
The post SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL appeared first on SQLServerCentral.
Oracle archived redo size – the research
In an earlier article, I explained why you might see log file switches taking place much more […]
Are your Oracle archived log files much too small?
Have you ever noticed that your archived redo logs can be much smaller than the online redo […]
SQL Developer – A great tool and better ways to ...
SQL Developer is a free tool provided by Oracle. It has a wide variety of options and […]
Why choose Oracle?
As an applications development professional, my career objectives are to do work that is fulfilling in the […]
What is Oracle ASM to Azure IaaS?
There is a natural desire for us to make sense out of confusion, and Oracle is a […]
Deployment Suite for Oracle: What’s New? Git Integration in Redgate ...
The post Deployment Suite for Oracle: What’s New? Git Integration in Redgate Change Control v3.0 appeared first on […]
6 New Courses Published on the Redgate University
The post 6 New Courses Published on the Redgate University appeared first on SQLServerCentral.
Automating Oracle Database Deployments using the Hybrid Approach
The post Automating Oracle Database Deployments using the Hybrid Approach appeared first on SQLServerCentral.
Solving Oracle Performance Issues in 4 Easy Steps
The post Solving Oracle Performance Issues in 4 Easy Steps appeared first on SQLServerCentral.
Automate Oracle database deployments with Redgate Change Automation
The post Automate Oracle database deployments with Redgate Change Automation appeared first on SQLServerCentral.
Perform Data Filtering in Oracle Link to SQL Server
In SQL Server, it’s easy to set up a linked server to Oracle and get data from there. […]