PLSQL2 [ORACLE] TABLE JOIN IN SQL When I want to join with tables, you need to use JOIN function For example, TABLE_1: EMPLOYEES TABLE_2: EMP_DETAILS_VIEW And if the colume is same as COLUME THEN, SELECT * FROM TABLE_1 A JOIN TABLE_2 B ON A.COLUME = B.COLUME; Refer to the following example SELECT * FROM EMPLOYEES A JOIN EMP_DETAILS_VIEW B ON A.EMPLOYEE_ID = B.EMPLOYEE_ID; 2019. 9. 18. [ORACLE] Creating User account in Oracle Database 11g Exchage First of all, You have to connect SYSTEM account in SQL Developer. Then you can easily find permit some account (for example, HR) and grant account's passcode 1. Grant USER HR ALTER USER HR ACCOUNT UNLOCK IDENTIFIED BY "Snut11221%"; SHOW USER; 2019. 9. 18. 이전 1 다음
