boolean datatype

[Guest_imported]

As you know, Oracle database does not recognize boolean as a datatype.
However, I am trying to work around that by creating a field as char(1) and manipulating that field.
The problem that I am having is that instead of returning values of Y or N as indicators of Yes or No,
I need to use a check mark for Y and X for no.
Is there any way of doing this in Oracle?
I know that this is a tough one.
sokeh

 

[rcurva]

Nope, and I suggest for you not to do such. Instead, use your front-end tool to handle the check-box thing.

 

[sem]

Try to use decode() function.

 

[THoey]

Since Oracle itself is not a front end tool, it is just a data repository, I agree with rcurva and sem. Create a field, I suggest a number type, with the possible values of -1 for true and 0 for false (You could use what ever you want). Then, on your front end application, you could test the value with DECODE (or whatever language specific test you have) to turn the check on or off. Terry M. Hoey

 

[Guest_imported]

Great!
Thanks my heroes! I didn't think that was possible.
But it is always a good idea to imagine.
sokeh