CHAR datatype in oracle

Published on by LakshmiSaahul,Dhana Royal

CHAR datatype

Char contain alphanumeric data.

  • Length of Char datatype is between 1 and 255 characters.
  • If you don't specify a length, a char column stores a single character by default.
  • Char datatypes stores data in the Fixed-Length Format.
  • Be aware, when using this data type, that spaces are padded to the right of the value to supplement the total allocated length of the column.
  • It can be declared as char(size) where size is the total length allowed for a value in a column defined as char.

You might al

Advertising
To be informed of the latest articles, subscribe:
Comment on this post