pl/sql里面有
oracle sql没有,pl/sql 有
BOOLEAN
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.
建表里不行,用number或者char来代替吧
对,建表时无布尔型数据,只能用别的数据类型来代替。
oracle 的sql 中是没有,但PL/SQL中是有的,那在建立数据库时可以使用 number来代替