Oracle DWBI

Tuesday, June 14, 2022

Oracle SQL Binary Data types

These data types are useful to store images, thumb impressions,logos, video and audio files.

 RAW(size)

Max size is 2000 bytes.

From oracle 12c , the max size was increased to 32767 bytes.

LONG RAW(size)

It is similar to RAW data type but supports  max 2 GB size.

NOTE:

Only for one column use long raw() data type
Posted by Dileep Kumar at 10:55 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Dileep Kumar
View my complete profile

Blog Archive

  • ▼  2022 (22)
    • ▼  June (22)
      • Oracle SQL Insert by Using Address Method
      • Oracle SQL Insert
      • Oracle SQL Create Table Using Select Statement
      • Oracle SQL Create Table Naming Rules
      • Oracle SQL Create Table
      • Oracle SQL Commands
      • INTERVAL DAY TO SECOND Data Type
      • INTERVAL YEAR TO MONTH Data Type
      • TIMESTAMP WITH TIME ZONE Data Type
      • Oracle SQL TIMESTAMP Data Type
      • Oracle SQL Float Data Type
      • Oracle SQL DATE data type
      • Oracle SQL NCHAR and NVARCHAR2 Data Types
      • Oracle SQL LOB--Large Objects
      • Oracle SQL Binary Data types
      • Oracle SQL Varchar2 Data Type
      • Oracle SQL CHAR Data Type
      • Oracle SQL Number or Numeric Data Type
      • Oracle SQL Data Types
      • Oracle SQL Delete Duplicate records from table
      • Oracle SQL Difference between Delete and Truncate
      • Oracle SQL Replace Male to Female and Female to Male
Simple theme. Powered by Blogger.