Pythian Blog: Technical Track | SQL

Recent stories

Expand your Oracle Tuning Tools with dbms_utility.expand_sql_text

Expand an Oracle View to Full SELECT Text When working on a view composed of SELECT statements on other views, it can ...

9 min read

Slow query to V$ views after DBRU Patching

One of our clients patched its EBS database 19.13 to DBRU 19.17 and faced an issue with one of the seeded programs. The ...

by Timur Akhmadeev

3 min read

Leverage Snowflake Tagging to Empower Governance

As the amount of data organizations collects grows, managing that data becomes increasingly complex. That’s where data ...

by Warner Chaves

3 min read

More stories

Google Cloud Platform

How to deploy a Cockroach DB Cluster in GCP – Part I

Oracle E-Business Suite

Slow Query in eBS AutoConfig with DB 19c

Oracle

Oracle Scheduler Job is Not Running as Expected After Bouncing Databases

Azure

SQL Server Distributed Availability Group with Forwarder in Microsoft Azure

Google BigQuery

Data preparation with dbt and BigQuery

Oracle

How To Rename Interval Partition with More Meaningful Name

Oracle

DML by Unique Index Supposedly Affecting Many Rows

SQL

Azure Synapse Analytics Q1 2021 Updates

Rdbms

Graph Algorithms and Inference

Oracle

Select vs Assign – How To Assign PL/SQL Variables

Oracle

How to Make Oracle Use the Correct Index

Oracle

How To Downgrade Grid 19c Clusterware to 12.1

Oracle

Examining distributed training of Keras Models

Oracle

An Oracle "oraenv" script solution for Windows with PowerShell

Oracle

Oracle 18c Non-CDB databases in the Oracle Database Cloud Service (ODBCS)

SQL

How to display database statistics for all objects used in a SQL statement