TechView with Kamlesh khaliya

Resources for OCP, Oracle Interviews(kamleshkhaliya@gmail.com)

Thursday 15 March 2012

Datatypes available in Oracle PL/SQL ?



We have four major category of data types in Oracle PL/SQL :
Scalar data types : Which have atomic values and don't have internal components, such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN.
Composite data types : Which have internal components and can be accessed individually, such as RECORD & TABLE.
Reference Data Type : Which have the reference of other data items like cursor variables in case of ref-cursors.
Large Object Data Type : Which contains the pointers to large objects stored seperately like vedio, test etc.

1 Comments:

  • At 6 May 2012 at 17:32 , Anonymous Anonymous said...

    Hi,

    This is really good catetorization of datatype in oracle. Nice!

     

Post a Comment

Subscribe to Post Comments [Atom]

<< Home