SQL> show user
USER is "TEST"
SQL> conn oe/oe
Connected.
SQL> SELECT i.product_id, i.quantity_on_hand , pi.supplier_id
2 FROM product_information pi JOIN inventories i
3 ON (pi.product_id=i.product_id) AND quantity_on_hand < 5;
PRODUCT_ID QUANTITY_ON_HAND SUPPLIER_ID
---------- ---------------- -----------
1768 3 102093
1772 4 102070
1770 4 102050
1763 3 102069
1769 3 102050
2359 3 102061
1940 0 103095
7 rows selected.
SQL> conn oe/oe as sysdba
Connected.
SQL> SELECT i.product_id, i.quantity_on_hand , pi.supplier_id
2 FROM product_information pi JOIN inventories i
3 ON (pi.product_id=i.product_id) AND quantity_on_hand < 5;
FROM product_information pi JOIN inventories i
*
ERROR at line 2:
ORA-00942: table or view does not exist
AS DBA 和 NORMAL 连接相当于两个身份 DBA 相当与SYS NORMAL 才是自己
最新推荐文章于 2023-04-14 18:15:02 发布