Data Warehousing Community Forum
February 08, 2012, 11:12:22 am

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Different Datatypes in PL/SQL ?  (Read 823 times)
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« on: June 27, 2007, 09:32:04 am »
Hi friends,

What are different Datatypes available in PL/SQL?
Is there any difference between oracle datatypes and PL/SQL datatypes?

Please mention different categories of Datatypes also (PL/SQL)?
Logged
Sipra
Founder

www.dwforum.net
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: June 27, 2007, 10:04:46 am »
PL/SQL datatypes are classified as Scalar Datatypes and Composite Datatypes.

Scalar Datatypes
  • Number
  • Char
  • Varchar2
  • Date
  • Long
  • Boolean

Composite Datatypes
  • Record
  • Table

These are the different datatypes in PL/SQL (that I know)
Logged
If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: