---
title: "Discussion on \"Faster operations with CLOBs\" | Hashnode"
description: "Discussion on \"Faster operations with CLOBs\". Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less defined. This was a good thing because the typical operations you would do with a VARCHAR2, for example, SUBSTR, REPLACE, ..."
url: "https://hashnode.com/posts/faster-operations-with-clobs/638f05b8483ccb28bb24ecae"
---

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

Discussion

# [Faster operations with CLOBs](https://connormcdonald.hashnode.dev/faster-operations-with-clobs?utm_source=hashnode&utm_medium=feed)

Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less defined. This was a good thing because the typical operations you would do with a VARCHAR2, for example, SUBSTR, REPLACE, ...

Dec 6, 2022 · 4 min read · connormcdonald.hashnode.dev  
Updated Dec 12, 2022  
Read the article

-   [#developers](https://hashnode.com/tag/developers)
-   [#sql](https://hashnode.com/tag/sql)
-   [#plsql](https://hashnode.com/tag/plsql)
-   [#uncategorized](https://hashnode.com/tag/uncategorized)
-   [#oracle](https://hashnode.com/tag/oracle)

## Written by

[Connor McDonald](https://hashnode.com/@connormcdonald)

@connormcdonald · Perth, Australia

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

I help people succeed with the Oracle Database

## Responses

Markdown supported · ⌘↵ to post

No responses yet.