Maria Colgan
@sqlmaria.com
230 followers
21 following
10 posts
Oracle Database Product Manager with a passion for SQL, AI, and the Optimizer. Wildlife photographer and Lego builder. Views expressed are my own.
SQL - 🌟
Oracle - ⭕️
Databases - ⛁
Product Manager - 🙊
World Traveler - 🧳
Posts
Media
Videos
Starter Packs
Maria Colgan
@sqlmaria.com
· Jun 25
Views are a handy way to reuse common joins
But how do you check a view has the joins you want?
Get the full underlying query in Oracle Database with
dbms_utility.expand_sql_text ( 'SELECT * FROM view', output_sql_text => :clob_var )
print :clob_var
@sqlmaria.com demos
But how do you check a view has the joins you want?
Get the full underlying query in Oracle Database with
dbms_utility.expand_sql_text ( 'SELECT * FROM view', output_sql_text => :clob_var )
print :clob_var
@sqlmaria.com demos
How to determine which view is the right view to use in Oracle?
Database views are a handy tool to help obfuscate complex joins from developers and analysts. However, knowing which view to use can be tricky, especially when faced with multiple views with simila…
buff.ly
Maria Colgan
@sqlmaria.com
· Jan 6
Oracle Exadata: Next-Generation Intelligent Data Architecture | LinkedIn
Join Kothanda Umamageswaran, SVP of Exadata and Scale-Out Technologies and Bob Thome, VP of Exadata Product Management for the announcement of the newest Oracle Exadata system delivering extreme perfo...
www.linkedin.com
Maria Colgan
@sqlmaria.com
· Nov 20