(ORACLEWITHAS用法大全.docVIP

ORACLE WITH AS 用法 有两张表，分别为A、B，求得一个字段的值先在表A中寻找，如果A表中存在数据，则输出A表的值；如果A表中不存在，则在B表中寻找，若B表中有相应记录，则输出B表的值；如果B表中也不存在，则输出no records”字符串。 view plaincopy to clipboardprint? with?? sql1?as?(select?to_char(a)?s_name?from?test_tempa),?? sql2?as?(select?to_char(b)?s_name?from?test_tempb?where?not?exists?(select?s_name?from?sql1?where?rownum=1))?? select?*?from?sql1?? union?all?? select?*?from?sql2?? union?all?? select?no?records?from?dual?? ???????where?not?exists?(select?s_name?from?sql1?where?rownum=1)?? ???????and?not?exists?(select?s_name?from?sql2?where?rownum=1);?? 再举个简单的例子 with a as (select * fr