본문 바로가기

Information Technology13

[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.
How to grant root authority to specific accounts(Super authority Permission) in Linux CentOS7 Depending on the server operator's operating policies, this may be necessary, but not recommended! If you create a subroot account separately and change the existing root account to make it inaccessible, you will have some security against simple server attacks. Now there are a total of three files that need to be modified to work. All of this must be done after first logging in to the root acco.. 2019. 8. 19.
[HTML5] 06. Training for LINK Tag 1-1. Making a.html with css indication Image example #2 1-2. Making default.css a { font-size: 50px; color: rgb(165, 158, 53); font-weight: 500; } 1-3. Export Result when open a.html via Chrome browser 2019. 8. 19.
[HTML5] 05. Training for Directory At First, Create a folder where you want in desktop directory and migrate imagefiles I made previous class time into created folder. Now, you can view the files and folder Image example Image example #2 Image example #3 Final. In case already migrated to another filder with html such as below? Image example Image example #2 Image example #3 2019. 8. 19.
[HTML5] 04. Training for IMG Tag (Image Tag) 1-1. href Image1 **Caution: Image has no rules of closing tag! Then, save as another file (.png) Start Coding for this! Image example Results 1-2. href Image1 + href Image2 Image example Image example #2 1-3. href Image1 + href Image2 + Just Image3 Image example Image example #2 Image example #2 2019. 8. 18.
[HTML5] 03. Training for A Tag Naver Google Daum 2019. 8. 18.
[HTML5] 02. Training for Tagging DIV functions Execute Visual Studio Tag New file in Visual Studio Code Save as another name in there. 1. Basic Code 1 2 3 2. Example 2-1. Input 2-2. Output 3-1. Input 3-2. Output 4. FUNCTION OF TAGGING "DIV" ※HTML commands must be decoded from top to bottom. Also, if the line is the same, the command is executed from left to right. 2019. 8. 18.

티스토리툴바