Everything From how to write simple SQL and PL/SQL statements to new features of the language, Creating functions, Stored procedures, complex queries, solutions to real world challenges and much more. In this Category I will post about the Language that has been around for a while and is still going strong Oracle SQL and it’s procedural extension PL/SQL
A BRIEF PRIMER: VIEWS Views are a great feature of the database, they are stored SQL queries that can be reused again and again without the need for rewriting the entire code. If a view has a filter in it however, and maybe you want to see the same resulting columns that the view generates […]
Creating “views” That accept input using SQL Macros 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 »
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
