Aug 24, 2026 · Databases

One‑Line Queries: Using Database Views to Encapsulate Complex SQL

This article explains how database views act as virtual tables that store only query logic, allowing developers to replace repetitive, multi‑join SQL statements with a single, reusable query while improving consistency, hiding sensitive fields, and boosting development efficiency.

Data ModelingDatabase ViewsQuery Optimization

0 likes · 4 min read

One‑Line Queries: Using Database Views to Encapsulate Complex SQL

Aikesheng Open Source Community

Oct 18, 2023 · Databases

Diagnosing and Resolving USER_TAB_COLUMNS View Inconsistencies Between Oracle and OceanBase

This article investigates why Oracle and OceanBase return different results when querying the USER_TAB_COLUMNS view in stored procedures, demonstrates reproducible tests, analyzes system view behavior, and proposes workarounds such as using ALL_TAB_COLUMNS, creating synonyms, intermediate tables, or materialized views to ensure consistent table name retrieval.

Database ViewsMaterialized ViewOceanBase

0 likes · 19 min read

Diagnosing and Resolving USER_TAB_COLUMNS View Inconsistencies Between Oracle and OceanBase