---
title: "Discussion on \"Virtual Columns No Longer Have to Be Virtual: Materialized Expression Columns in Oracle 23ai\" | Hashnode"
description: "Discussion on \"Virtual Columns No Longer Have to Be Virtual: Materialized Expression Columns in Oracle 23ai\". Virtual columns were introduced in Oracle 11g to conveniently include computed logic directly in a table, appearing just like any other column. The expression used must be deterministic, meaning it must always produce the same result given the same i..."
url: "https://hashnode.com/posts/virtual-columns-no-longer-have-to-be-virtual-materialized-expression-columns-in-oracle-23ai/68538b5d9dd17fb2bc1718d5"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Virtual Columns No Longer Have to Be Virtual: Materialized Expression Columns in Oracle 23ai](https://philgrinham.hashnode.dev/virtual-columns-no-longer-have-to-be-virtual-materialized-expression-columns-in-oracle-23ai?utm_source=hashnode&utm_medium=feed)

Virtual columns were introduced in Oracle 11g to conveniently include computed logic directly in a table, appearing just like any other column. The expression used must be deterministic, meaning it must always produce the same result given the same i...

Jun 19, 2025 · 3 min read · philgrinham.hashnode.dev  
Read the article

-   [#oracle](https://hashnode.com/tag/oracle)
-   [#oracle-23ai](https://hashnode.com/tag/oracle-23ai)
-   [#ddl](https://hashnode.com/tag/ddl)

## Written by

[Phil Grinham](https://hashnode.com/@PhilGrinham)

@PhilGrinham

  
[View profile](https://hashnode.com/@PhilGrinham)

Certified Oracle Developer

I am a Certified Senior Oracle Developer/Data Architect with a passion for all things data and an advocate for the Oracle APEX low code platform that I have seen mature to become a fully-fledged enterprise level solution. I have several decades of experience in multiple industries such as Finance, Energy and the Public Sector and hope that I can impart some of that experience in my blog posts.

## Responses

Comments are turned off for this post.
