본문 바로가기

Information Technology/Oracle Database4

[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.
[Oracle] Practice SQL queries without installing or installing a DB Good information! **By logging in with your Oracle account, you can easily practice queries without having to set up a database. ▶ Preparation You need to prepare an Oracle account. ▶ Advantages - No DB setting required - You can easily practice the query When you log in, you will see a screen like the one above. In the search box that appears, search for HR and click the red box. (Query URL for.. 2019. 8. 24.
[Oracle] How to kill a locked user's session -- 01. Check the locked table SELECT do.object_name, do.owner, do.object_type, do.owner, vo.xidusn, vo.session_id, vo.locked_mode FROM v$locked_object vo , dba_objects do WHERE vo.object_id = do.object_id ; -- 02. Find out which table is locked SELECT A.SID, A.SERIAL#, B.TYPE, C.OBJECT_NAME FROM V$SESSION A, V$LOCK B, DBA_OBJECTS C WHERE A.SID=B.SID AND B.ID1=C.OBJECT_ID AND B.TYPE='TM' AND C.OB.. 2019. 8. 24.

티스토리툴바