17,377
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
LoveSQL 2004-04-14
- 打赏
- 举报
谢谢各位
gisbeibei 2004-04-14
- 打赏
- 举报
好像没看到!
你可以用0和1；"false" and "true"来表示啊
你可以用0和1；"false" and "true"来表示啊
welyngj 2004-04-14
- 打赏
- 举报
BOOLEAN
在pl/sql里：
You use the BOOLEAN datatype to store the logical values TRUE, FALSE, and NULL (which stands for a missing, unknown, or inapplicable value). Only logic operations are allowed on BOOLEAN variables.
The BOOLEAN datatype takes no parameters. Only the values TRUE, FALSE, and NULL can be assigned to a BOOLEAN variable. You cannot insert the values TRUE and FALSE into a database column. Also, you cannot select or fetch column values into a BOOLEAN variable.
在pl/sql里：
You use the BOOLEAN datatype to store the logical values TRUE, FALSE, and NULL (which stands for a missing, unknown, or inapplicable value). Only logic operations are allowed on BOOLEAN variables.
The BOOLEAN datatype takes no parameters. Only the values TRUE, FALSE, and NULL can be assigned to a BOOLEAN variable. You cannot insert the values TRUE and FALSE into a database column. Also, you cannot select or fetch column values into a BOOLEAN variable.
LoveSQL 2004-04-14
- 打赏
- 举报
那就是说在oracle中没有专门的布尔数据类型了？
shuangyu 2004-04-14
- 打赏
- 举报
我用number(1)
nicholaz 2004-04-14
- 打赏
- 举报
用number，char都可以，只要你知道代表的含义即可，如1代表真，0代表假等等
