THE NEW METADATA? Historically,(since about oracle 7) Developers and Database Administrators have had the ability to provide more information about a database column, unified audit policy, edition, indextype, materialized view, mining model, operator, or view using comments. In Oracle AI Database 26 AI, we can go even further an extend he capability of descriptive text […]
With the launch of Oracle AI Database 26 AI, excitement is buzzing among IT professionals! This new version promises a host of innovative features that will transform the way we manage databases. From the groundbreaking removal of the DUAL table to the game-changing SQL Firewall that enhances security, these updates are designed to make a DBA’s life easier and more efficient. Imagine shrinking tablespaces effortlessly or prioritizing critical transactions without the usual headaches. Dive into this blog to discover the features that will revolutionize your database experience and learn how they can benefit you!
My Favorite Features of Oracle AI Database 26 AI Read More »
Unlock the secrets of Oracle’s hierarchical queries and discover how to tackle complex Bill of Material (BOM) structures! In this insightful blog post, we delve into a real-world challenge: calculating the total reorder lead time for parts needed to build a car or bike. With a blend of SQL and PL/SQL, we explore the intricacies of parent-child relationships in data, revealing how to efficiently navigate through layers of components. Join us on this journey to master hierarchical queries and enhance your database skills—your BOM management will never be the same!
Solving Complex BOM Structures with Oracle Hierarchical Queries Read More »
Are you a database administrator grappling with performance issues? Don’t panic just yet! Discover essential strategies to troubleshoot and enhance your database performance. From identifying problematic SQL to understanding cardinality and execution plans, this guide offers practical insights drawn from real-world experience. Learn how to optimize your queries, leverage Oracle’s powerful tuning tools, and understand the critical role of database design in performance tuning. Whether you’re facing slow queries or just want to improve efficiency, this post is your roadmap to a faster, more responsive database. Dive in and transform your approach to performance tuning!
PL/SQL or Procedural Language SQL is SQL’s extension. It’s a very neat language for writing functions, stored procedures, triggers all helping applications that run on databases. I like playing around with PL/SQL in my free time. Here are some Functions/procedures I have written for the heck of it in PL/SQL some of Which can be
“If you have knowledge, let others light their candles in it.”Margaret Fuller. Ah yes, nothing like a good quote to make a point. Before writing this I actually went looking around for a cool attention grabbing headline that will make everyone wanna read this blog post however This one stood out to me and I
“I can’t connect to the database. Can you please check if it’s shutdown and start it up please, Thanks” I was asked by a savvy developer once upon a time, and when I did ” Start the database” I asked them to try connecting again and they could. I then replied the database was never
