zhouxzcsdn的博客

Oracle通过CONNECT BY根据特定字符拆分字符串

以sqlserver为例：⑧ select ⑨ distinct <Top num> ⑪ <select list>① from [left_table]③ <join_type> join <right_table>② on <join_condition>④ where <where_condition>⑤ group by <group_by_list>⑥ with <CUBE

Oracle中 数字的空、字符串的空、对象的空，都可以写成is null

UPDATE UNIT U SET U.BASED_LOT_RRN = (SELECT L.BASED_LOT_RRN FROM LOT L WHERE U.LOT_RRN = L.lot_rrn)Oracle，多表关联update，需要EXISTS update UNIT_SP_TEST_PROG G set file_column = ‘VFBC’ where EXISTS (SE

Oracle null值处理数据库处理null值特点：除了nvl()函数之外,任何函数、运算符遇到值为 null 或者’’ 的数据都会被过滤掉 备注：oracle数据库中 null <==> ‘’with T as (SELECT '101' ID,null as the_name from dual)SELECT 1 "序号",count(*) NUM FROM T unio...