Views

Thumbnail image for Find Which Objects are INVALID in Oracle – and Why

Find Which Objects are INVALID in Oracle – and Why

Oracle objects become invalid when a dependency chain is broken. Here’s how to find invalid Oracle objects and how to make them valid again.

Read the Full Article →
XMLTABLE to convert XML to relational data

XMLTABLE: Convert XML Data to Relational Form

Using the SQL/XML function XMLTABLE in Oracle database 12c, to map XML data into relational rows and columns.

Read the Full Article →
Thumbnail image for Grant SELECT on V$ Views

Grant SELECT on V$ Views

Grant SELECT on V$ views to allow non-admin database users to query SYS-owned V$ views (dynamic performance views) such as V$INSTANCE or V$SESSION.

Read the Full Article →
Thumbnail image for How to Find out Your Oracle Database Version

How to Find out Your Oracle Database Version

Three ways to find out your Oracle database version in SQL and PL/SQL: using V$VERSION, V$INSTANCE, or DBMS_DB_VERSION constants.

Read the Full Article →
Thumbnail image for How to Cast PLSQL Function Output as View

How to Cast PLSQL Function Output as View

How to cast PLSQL function output as view, when a single SQL statement is not sufficient to get the result you want.

Read the Full Article →
Thumbnail image for The Difference Between Views and Materialized Views

The Difference Between Views and Materialized Views

Key differences between views and materialized views in Oracle, with guidelines to help you decide if a specific scenario needs a view, a materialized view, or neither.

Read the Full Article →
Oracle Views

20 Things You Should Know About Oracle Views

This one just might fail the Duck Test. It looks like a table, acts like a table, responds to SQLs like a table – but it is NOT a table. Learn about features and best practices for dealing with Oracle views.

Read the Full Article →