[摘要] 1. 创建测试表TBL_STAT，及索引，但不插入记录SQL> create table TBL_STAT as select * from dba_objects where 1<>1;Table created.SQL> create index idx_tbl_stat on tbl_stat[全文]
[摘要] 需求：现在oracle数据库中有字段is_use 的有：null,0,1,2。现在需要查询不等于2的数据解决办法的sql：select * from uc_Users where nvl(is_use,'xx')<>'2'=======================================...[全文]
