• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Boolean data type in Oracle

 
sudha swami
Ranch Hand
Posts: 186
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I would like to know whether boolean data type is supported in Oracle 9.2.0.4? Currently using NUMBER or VARCHAR2.
Thanks
Sudha
 
Bhagat Singh Rawat
Ranch Hand
Posts: 93
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sudha swami wrote:
I would like to know whether boolean data type is supported in Oracle 9.2.0.4? Currently using NUMBER or VARCHAR2.


No there is no build-in boolean data type in Oracle.

"A common space-saving trick is storing boolean values as an Oracle CHAR, rather than NUMBER"
- Data Type in Oracle
- Click Here
 
sudha swami
Ranch Hand
Posts: 186
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks
 
Bhagat Singh Rawat
Ranch Hand
Posts: 93
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sudha swami wrote:thanks


Always Welcome
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic