2016年
-
编辑 删除
同义词循环连处理方法
1、先查有没有循环的同义词： select * from dba_synonyms where table_owner='test' and synonym_name <>table_name;没有记录 2、再查同义词没...
-
编辑 删除
考驾流程图
-
编辑 删除
行转列
WITH tab AS( SELECT 1 as col1, 2 as col2, 'Smith' as created_by FROM dualUNION ALL SELECT 1 as col1, 2 as col2, 'John' as created_by FROM dualUNION ALL SELECT 1 as col1, 3 as ...
