Showkat's Blog
  • Home
  • PLSQL
  • EBS
Sign in

SQL

A collection of 2 posts
Oracle Row Level Security
SQL

Oracle Row Level Security

A Practical Guide to Row Level Security for a SaaS In the world of multi-tenant SaaS applications, data segregation is not just a feature—it's a foundational requirement. The cardinal rule is simple and absolute: one customer must never, under any circumstances, see another customer's data.
02 Oct 2025 5 min read
SQL PIVOT
EBS

From Rows to Columns - PIVOT in Oracle SQL

In the world of database development, transforming data is a daily task. One of the most common requirements, especially for reporting and analytics, is to pivot data—turning unique row values into distinct columns. This is essential for creating summary reports that are easy to read and understand. For instance,
25 Jul 2025 5 min read
Page 1 of 1
Showkat's Blog © 2026
  • Sign up