---
title: "8 Date Types of Oracle SQL You Need"
description: "8 Everyday Use Oracle data types by database developers and in data warehousing projects."
url: https://srinimf.com/2016/08/02/8-different-data-types-in-oracle/
date: 2016-08-02
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2016/08/forest-tree-tree-trunk-bark.jpg?fit=1880%2C1253&ssl=1
categories: ["Oracle"]
tags: ["Frequently used Oracle data types for quick reference"]
type: post
lang: en
---

# 8 Date Types of Oracle SQL You Need

The [data types](https://srinimf.com/2012/06/17/db2-large-object-data-types-lob/) in Oracle are Numeric, Varchar, Varchar2, Date, LOB, CLOB and BLOB

Related[8 Date Types of Oracle SQL You Need](https://srinimf.com/2016/08/02/8-different-data-types-in-oracle/)

Char(20)- This means it takes 20 bytes of storage. Max limit is 20.

Related[How to Migrate DB2 BLOB to Oracle](https://srinimf.com/2013/03/02/db2-to-oracle/)

Varchar(20)- If you give ‘abcd’ only 4 bytes storage it takes. Max limit is [2000](https://srinimf.com/2015/04/08/cobol-2000-change-in-perform/) bytes.

Varchar2- Max limit is 4000 bytes

Char, Varchar and in Varchar2 String is case sensitive.

Related Posts

- [DB2 Numeric, String, Date, Time Data types](https://srinimf.com/2015/08/17/db2-numeric-string-date-time-data-types/)DateAugust 17, 2015
- [Exclusive CHAR Vs. VARCHAR in DB2 SQL](https://srinimf.com/2022/01/03/exclusive-char-vs-varchar-in-db2-sql/)DateJanuary 3, 2022
- [SQL Like Statement with CHAR and VARCHAR: Top Differences](https://srinimf.com/2023/12/08/why-like-works-differently-on-char-and-varchar/)DateDecember 8, 2023

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2016%2F08%2F02%2F8-different-data-types-in-oracle%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2016%2F08%2Fforest-tree-tree-trunk-bark.jpg%3Ffit%3D1200%252C800%26ssl%3D1&description=8%20Date%20Types%20of%20Oracle%20SQL%20You%20Need)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2016/08/02/8-different-data-types-in-oracle/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2016/08/02/8-different-data-types-in-oracle/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2016/08/02/8-different-data-types-in-oracle/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2016/08/02/8-different-data-types-in-oracle/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%208%20Date%20Types%20of%20Oracle%20SQL%20You%20Need&body=https%3A%2F%2Fsrinimf.com%2F2016%2F08%2F02%2F8-different-data-types-in-oracle%2F&share=email)
-

### Like this:

Like Loading…