N1 N2 N3 N4 -- ---------- ---------- ---------- A 456 34 55 B 135 345 643 B 456 34 55 A 123 235 B 332 534 C 135 643 A 789 342 B 365 774
8 rows selected.
SQL> select * from c where c.n1='A';
no rows selected
c 是我建的一个用a,b 两个表连接的view 请问为什么没有返回行呢? 建视图 的语句贴出来 create view c as select nvl(a.n1,b.n1) as n1,nvl(a.n2,b.n2) as n2,n3,n4 from a full join b on a.n1=b.n1 and a.n2=b.n2; 顺便问一句 其中空的位置 是存的null吗 还是根本那个位
oracle 11g 安装 01092 错误, 日志信息: [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......