一条数据的真假你用一个仅有0和1两个值的字段不就可以判断了。
老兄说这个问题我才注意到,呵呵,我用oracle 开发都一年多了,也许是因为布尔值字段在数据库里根本就没有实际用处吧
老兄说这个问题我才注意到,呵呵,我用oracle 开发都一年多了,也许是因为布尔值字段在数据库里根本就没有实际用处吧
解决方案 »
- ResultSet的getRow()返回的是一个int,如果数据量很大,超过int类型的范围会怎么样?
- oracle头疼问题,为什么我数据用户改了密码后。。。
- 点击editdata按钮,为什么会跳出错误“these query result are not updateable....”
- 关于oracle 9i as 的问题
- 基础存储过程问题
- 准备学oracle,想在自己机上装一个oracle,问一下oracle的基本配置是多少啊?
- sysdba、sysoper、normal在登陆connect as时的区别?谢谢!
- 问一个关于jdbc连接的问题
- %FOUND %TYPE是什么意思?
- 如何用一条sql完成表内的求和平均并更新某字段的问题??
- 请教
- 初学者,up 有分
char(1)也可以的,需要前台的处理呀
OracleTypes.???中没有BOOL型,还是别用了。
• Unique identifier for a row
• Used to locate a rowRAW Data Type :
This data type enables the storage of small binary data. The Oracle
server does not perform character set conversion when RAW data is transmitted across machines in a network or if RAW data is moved from one database to another using Oracle utilities. The number of bytes needed to store the actual column value vary in size for each row, up to 2,000 bytes.Oracle provides six data types for storing LOBs:
• CLOB and LONG for large fixed-width character data
• NCLOB for large fixed-width national character set data
• BLOB and LONG RAW for storing unstructured data
• BFILE for storing unstructured data in operating system filesComparing LONG and LOB Data Types:
LONG, LONG RAW
1。Single column per table
2。Up to 2 gigabytes
3。SELECT returns data
4。Data stored in-line
5。No object type support
6。Sequential access to chunksLOB
1。Multiple columns per table
2。Up to 4 gigabytes
3。SELECT returns locator
4。Data stored in-line or out-of-line
5。Supports object types
6。Random access to chunks