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
来源:学生作业帮助网 编辑:作业帮 时间:2024/09/08 06:46:01
![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](/uploads/image/z/14343911-71-1.jpg?t=SELECTi.id_number%2Cm.manufacturer_nameFROM+inventory+i%2Cmanufacturer+mWHERE+i.manufacturer_id%28%2B%29+%3D+m.id_number%3BWHERE+%E5%AD%90%E5%8F%A5%E4%B8%AD%E7%9A%84%EF%BC%88%2B%EF%BC%89%E6%98%AF%E4%BB%80%E4%B9%88%E5%90%AB%E4%B9%89A+%E5%B0%86inventory%E8%A1%A8%E4%B8%AD%E4%B8%8D%E6%BB%A1%E8%B6%B3%E6%9D%A1%E4%BB%B6%E7%9A%84%E8%AE%B0%E5%BD%95%E4%B9%9F%E6%9F%A5%E5%87%BA%E6%9D%A5B+%E5%B0%86i.manufacturer_id%2B+m.id_numberC%E5%B0%86manufa)
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
也就是把相等的先显示出来,然后不相等的也要显示出来