SELECTi.id_number,m.manufacturer_nameFROM inventory i,manufacturer mWHERE i.manufacturer_id(+) = m.id_number;WHERE 子句中的（+）是什么含义A 将inventory表中不满足条件的记录也查出来B 将i.manufacturer_id+ m.id_numberC将manufa

SELECTi.id_number,m.manufacturer_nameFROM inventory i,manufacturer mWHERE i.manufacturer_id(+) = m.id_number;WHERE 子句中的（+）是什么含义A 将inventory表中不满足条件的记录也查出来B 将i.manufacturer_id+ m.id_numberC将manufa
SELECTi.id_number,m.manufacturer_nameFROM inventory i,manufacturer m
WHERE i.manufacturer_id(+) = m.id_number;WHERE 子句中的（+）是什么含义
A 将inventory表中不满足条件的记录也查出来
B 将i.manufacturer_id+ m.id_number
C将manufacturer表中不满足条件的记录也查出来
D 不能这样写,语法错误
TO_DATE(’01-JAN-1998′) – TO_DATE(’01-DEC-1996′)
显示结果是数值还是字符串

SELECTi.id_number,m.manufacturer_nameFROM inventory i,manufacturer mWHERE i.manufacturer_id(+) = m.id_number;WHERE 子句中的（+）是什么含义A 将inventory表中不满足条件的记录也查出来B 将i.manufacturer_id+ m.id_numberC将manufa
相当于left jion
如果是i.manufacturer_id = m.id_number(+)
就相当于right join
也就是把相等的先显示出来,然后不相等的也要显示出来