Lightnews — Scholar-powered news

Maria Colgan

@sqlmaria.com

220 followers 21 following 9 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

Always best to know exactly what a view is doing before using it!

SQLDaily @sqldaily.bsky.social · May 28

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

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 · May 6

Juan Loaiza kicking off the Oracle Database keynote at #OCWTour NYC

Reposted by Maria Colgan

Jeff Smith @thatjeffsmith.com · Jan 23

"part of my job as a product manager to make sure the best, most timely information is out there" ... to train the LLMs.

Thanks to @sqlmaria.com for helping me write this post :)

Using AI and expert content to explain technology

I've spent a lot of time writing blog posts for my products. One of those is Oracle REST Data Services (ORDS), which according to the AI, is .

www.linkedin.com

1 5

Maria Colgan @sqlmaria.com · Apr 18

I had a blast chatting with Dave about all things #AI and #Database. If you want to hear more, join us at the DatabaseWorld in NYC, May 7th, where you can sharpen your skills and meet with Oracle DB experts, including @thatjeffsmith.com, @ashishray.bsky.social, and many more! lnkd.in/ggNs2DJJ

Maria Colgan, Oracle | CUBE Conversations 2025

YouTube video by SiliconANGLE theCUBE

youtu.be

3 11

Maria Colgan @sqlmaria.com · Apr 15

Join Juan Loaiza, @thatjeffsmith.com, @bhammers.bsky.social, and me in person at DatabaseWorld: Multicloud AI Edition on May 7 in New York. Learn about the latest database innovations that help you bring AI to your data across clouds. Learn more and register now at social.ora.cl/611000SOMs

1 5

Maria Colgan @sqlmaria.com · Jan 6

Join Kothanda Umamageswaran and Bob Thome on January 7 for the announcement of the newest @OracleExadata X11M system, delivering extreme performance for AI, OLTP, and analytics. Register at 👇https://www.linkedin.com/events/oracleexadata-next-generationin7280643074777563136/theater/