Home » SQL & PL/SQL » SQL & PL/SQL » enum data type
enum data type [message #17950] Sun, 06 February 2005 09:08 Go to next message
prathyusha
Messages: 2
Registered: January 2005
Junior Member
Is there a ENUM data type in oracle?
How do we store boolean values in a table?
Re: enum data type [message #17955 is a reply to message #17950] Sun, 06 February 2005 16:52 Go to previous message
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
Senior Member
There is no enum data type in Oracle and you cannot store boolean values in a regular database table. The boolean datatype is only available in pl/sql. You can store a varchar2 dataype of 'true' or 'false'.
Previous Topic: schema of an object
Next Topic: SQL Question - using instr function.
Goto Forum:
  


Current Time: Wed Aug 06 18:55:25 CDT 2025