Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Data TypeRSS Feeds

ORACLE DATATYPES

Posted By: Jack Bouchard     Category: Oracle     Views: 2717

This article explains about datatypes available in oracle.

CHAR(size)

Store char strings of fixed length. size determines no. of characters the field can hold.The remaining chars are padded with spaces.
e.g. if CHAR(10) and you inserted sanjay then remaining 4 chars will be spaces.

VARCHAR(size) 

This datatype is used to store variable length alphanumberic data. Maximum chars is 2000 chars.

DATE 

Represent data and time. Standard format is DD-MON-YY as in 21-JUN-02.To enter date other than standard format,use ORACLE DATE functions.

NUMBER (P,S)

Store numbers fixed or floating-point. P= precision,S=scale = no. of decimal points.
NUMBER(4,2)= 99.99

LONG

Variable length char strings upto 2 GB.

RAW/LONG RAW 

Store binary data such a picture file,image file. 
            Max length of RAW=255 bytes.
            Max length of LONG RAW=2BG.
  
Share: 


Didn't find what you were looking for? Find more on ORACLE DATATYPES Or get search suggestion and latest updates.

Jack Bouchard
Jack Bouchard author of ORACLE DATATYPES is from Montreal, Canada.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!