一条数据的真假你用一个仅有0和1两个值的字段不就可以判断了。
老兄说这个问题我才注意到,呵呵,我用oracle 开发都一年多了,也许是因为布尔值字段在数据库里根本就没有实际用处吧
老兄说这个问题我才注意到,呵呵,我用oracle 开发都一年多了,也许是因为布尔值字段在数据库里根本就没有实际用处吧
解决方案 »
- Oracle ERP 在Report Completed 后是否可以自動的 View Output
- 如何查找两个数据库user/role的表权限有不一样的
- LIKE '%_10' 查询结果 为什么出现F075010 ?
- 高分急求修改shard_pool_size问题!!!
- 哪位大侠给我解释一下Oracle的企业管理框架,谢谢了。
- powerdesigner 修改nhibernate模板以及C#语言模板
- 在oracle中怎样实现sqlserver中的 isnull(tab.field,"aa") 请大家指教!!!!!!
- 看了好多ORACLE分页语句还是看的不太懂拿位高人帮我看看改怎么写分页SQL语句
- 判断两个表记录完全相同的sql语句怎么写
- orcale 奇怪的问题?
- 请教
- 初学者,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