Home » SQL & PL/SQL » SQL & PL/SQL » boolean in table creation (oracle 10g)
boolean in table creation [message #382372] Thu, 22 January 2009 01:08 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
is it possible to create a table in sql with boolean as a data type

like

create table xyz(status boolean:=false);


[Edit MC: correct "boolean" in title]

[Updated on: Thu, 29 January 2009 00:40] by Moderator

Report message to a moderator

Re: boolen in table creation [message #382374 is a reply to message #382372] Thu, 22 January 2009 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No. This type is unknown for Oracle SQL.

Regards
Michel
Re: boolen in table creation [message #382375 is a reply to message #382372] Thu, 22 January 2009 01:17 Go to previous messageGo to next message
wmgonzalbo
Messages: 98
Registered: November 2008
Member
what have you tried so far?

Regards,
Wilbert
Re: boolen in table creation [message #383436 is a reply to message #382372] Wed, 28 January 2009 20:54 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
if you are determined to have such a thing, the roll your own.

read up on user define types in oracle. Learn how to create an object with member functions and map functions etc. Then read about creating your own operators. Then create what you need.

Once you are done, post it all, other people might like it.

Good luck, Kevin
Previous Topic: Please help me!!! its urgent(challenge to all experts)
Next Topic: im getting invalid expression
Goto Forum:
  


Current Time: Sat Feb 08 13:04:57 CST 2025