AS DBA 和 NORMAL 连接相当于两个身份 DBA 相当与SYS NORMAL 才是自己

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