有没有在Oracle数据库中一个boolean类型？ [英] Is there a boolean type in oracle databases?

问题描述

有没有布尔类型在Oracle数据库中，类似于MS SQL？

Is there a boolean type in oracle databases, similar to the BIT datatype in MS SQL?

推荐答案

不仅是布尔数据类型在Oracle的SQL（而不是PL / SQL）失踪，但他们也有什么，而不是使用没有明确的建议。见<一href=\"http://asktom.oracle.com/pls/asktom/f?p=100:11:0%3a%3a%3a%3aP11_QUESTION_ID:6263249199595#876972400346931526\">this螺纹上asktom。从推荐CHAR（1）'Y'/'N'他们切换到数字（1）0/1时，有人指出，'Y'/'N'依赖于英语，而如德国程序员可能用'J'/'N'代替。

Not only is the boolean datatype missing in Oracle's SQL (not PL/SQL), but they also have no clear recommendation about what to use instead. See this thread on asktom. From recommending CHAR(1) 'Y'/'N' they switch to NUMBER(1) 0/1 when someone points out that 'Y'/'N' depends on the English language, while e.g. German programmers might use 'J'/'N' instead.

最糟糕的事情是，他们的防守就像他们捍卫''= NULL愚蠢这个愚蠢的决定。

The worst thing is that they defend this stupid decision just like they defend the ''=NULL stupidity.

这篇关于有没有在Oracle数据库中一个boolean类型？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！