TestingDocs.com
    Software Testing website
    • Automation
      • Selenium
      • JBehave Framework
    • Tutorials
      • MySQL Tutorials
      • Testlink
      • Maven
      • Git
    • IDEs
      • IntelliJ IDEA
      • Eclipse
    • Flowcharts
      • Flowgorithm
      • Raptor
    • About

    Oracle

    Oracle SQL Data Types

    Overview

    Oracle SQL Data Types in a tabular format. Data type in one column and the Description of the data types in the second column. We will use some important data types in the database columns in the upcoming tutorials.

    SQL Data Types

     

    SQL Data Type Description
    VARCHAR2 (n)

    VARCHAR (n)

    Variable character string of maximum length n,
    n between 1 and 4000
    CHAR (n) Fixed character string of n bytes, n between 1 and 2000
    NCHAR , NVARCHAR Character strings with a different character set than that of the database
    DATE The DATE data type
    NUMBER (p, s) Decimal numbers
    RAW(n) Binary data
    LONG Variable string up to 2GB
    CLOB Strings up to 4GB
    BLOB Binary data up to 4GB
    CFILE pointer to a text file
    BFILE pointer to a binary file

     

    The manipulation of unstructured data is only possible with programming languages like PL/SQL, etc. The data types for unstructured data are :

    LONG, LONG RAW, LOBs, etc

    Related Posts

    Download SQL Developer

    Oracle /

    Download Oracle SQL Developer

    Oracle Databse 19c Download

    Oracle /

    Install Oracle 19c Database On Windows 10

    ORA-01109 Database Not Open

    Oracle /

    Fix ORA-01109: database not open Error

    Oracle SQL Update Statement

    Oracle /

    Oracle SQL Update Statement

    Oracle SQL Insert Statement

    Oracle /

    Oracle SQL INSERT Statement

    ‹ Oracle SQL LIKE Operator with Examples› Oracle Rename Table Statement

    Recent Posts

    • ChatGPT Plans Free and PlusChatGPT Subscription Plans
    • Stellar Converter for Database ToolStellar Converter for Database
    • Stellar MySQL Log AnalyzerStellar Log Analyzer for MySQL
    • Stellar Repair for MySQLStellar Repair for MySQL
    • ChatGPT IntroductionChatGPT Capabilities
    • How to secure your SQL Database: Tips and Tricks
    • ChatGPT4 Conversational AI FeaturesChatGPT4 Conversational AI Features
    • Trends in Software EngineeringShaping the Future of Development: Exploring Key Trends in Software Engineering
    • Java PerformanceImproving Java Performance with Multithreading
    • QDrant Vector DatabaseOpen-source Vector Databases
    • Difference between PHP and JavaScript?
    • Bing AI Browser Web ContentBing Conversation Styles
    • ChatGPT PreviewChatGPT Introduction
    • Open Source AI Frameworks TensorFlowOpen Source AI Frameworks
    • Artificial Intelligence Tools

    Back to Top

    Links

    • Contact
    • Privacy Policy
    • Cookie Policy

    www.TestingDocs.com