JavaScript 이론 및 실습

first.html 파일

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    <h1 id="heading">처음 페이지</h1>
    <input id="input"/>
    <button id="btn">클릭</button>
    
<script src="script.js">
  
</script>
</body>
</html>


script.js 파일

var heading = document.querySelector('#heading');
var inp = document.querySelector('#input');
var btn = document.querySelector('#btn');

btn.onclick = function(){
    heading.innerHTML = inp.value;
    console.log(inp.value)
    alert(inp.value);
}

heading.onclick = function(){
    var str = inp.value;
    console.log(str);
    heading.style.color = "red";
    
    
}

 

 

오라클 연습문제

 

데이터 정보

1. 이름 다섯글자 이상 6글자 미만, 첫, 두글자 빼고 나머지 *로 출력

 

2. 월 평균 근무일 수 21.5일 하루 근무시간 8시간 / 하루 급여 / 시급 계산 출력

select empno, ename, trunc(sal / 21.5, 2) as day_pay,
    round(sal/ 21.5 / 8, 1) time_pay
    
    from emp

     EMPNO ENAME         DAY_PAY   TIME_PAY
---------- ---------- ---------- ----------
      7839 KING           232.55       29.1
      7698 BLAKE          132.55       16.6
      7782 CLARK          113.95       14.2
      7566 JONES          138.37       17.3
      7788 SCOTT          139.53       17.4
      7902 FORD           139.53       17.4
      7369 SMITH            37.2        4.7
      7499 ALLEN           74.41        9.3
      7521 WARD            58.13        7.3
      7654 MARTIN          58.13        7.3
      7844 TURNER          69.76        8.7

     EMPNO ENAME         DAY_PAY   TIME_PAY
---------- ---------- ---------- ----------
      7876 ADAMS           51.16        6.4
      7900 JAMES           44.18        5.5
      7934 MILLER          60.46        7.6

14개 행이 선택되었습니다. 

 

3. 입사일 기준 3개월이 지난 후 첫 월요일에 정직원, 정직원 되는 날짜

 

 

 

4. 추가 수당 여부 ( 없으면 N/A  )로 출력

select empno, ename, hiredate ,
to_char(next_day(add_months(hiredate, 3),'월'), 'YYYY-MM-DD') R_JOB,
nvl(to_char(comm), 'N/A') comm

from emp;


     EMPNO ENAME      HIREDATE   R_JOB      COMM                                    
---------- ---------- ---------- ---------- ----------------------------------------
      7839 KING       1981/11/17 1982-02-22 N/A                                     
      7698 BLAKE      1981/05/01 1981-08-03 N/A                                     
      7782 CLARK      1981/06/09 1981-09-14 N/A                                     
      7566 JONES      1981/04/02 1981-07-06 N/A                                     
      7788 SCOTT      1987/07/13 1987-10-19 N/A                                     
      7902 FORD       1981/12/03 1982-03-08 N/A                                     
      7369 SMITH      1980/12/17 1981-03-23 N/A                                     
      7499 ALLEN      1981/02/20 1981-05-25 300                                     
      7521 WARD       1981/02/22 1981-05-25 500                                     
      7654 MARTIN     1981/09/28 1982-01-04 1400                                    
      7844 TURNER     1981/09/08 1981-12-14 0                                       

     EMPNO ENAME      HIREDATE   R_JOB      COMM                                    
---------- ---------- ---------- ---------- ----------------------------------------
      7876 ADAMS      0087/07/13 0087-10-15 N/A                                     
      7900 JAMES      1981/12/03 1982-03-08 N/A                                     
      7934 MILLER     1982/01/23 1982-04-26 N/A                                     

14개 행이 선택되었습니다. 

 

 

 

 

5. 직속 상관의 사원 번호를 기준에 맞게 바꿔서 출력

select empno, ename, mgr,
    case 
    when mgr is null then '0000'
    when substr(mgr,1,2) = 75 then '5555'
    when substr(mgr,1,2) = 76 then '6666'
    when substr(mgr,1,2) = 77 then '7777'
    when substr(mgr,1,2) = 78 then '8888'
    else to_char(mgr)
    end as chg_mgr
from emp


     EMPNO ENAME             MGR CHG_MGR                                 
---------- ---------- ---------- ----------------------------------------
      7839 KING                  0000                                    
      7698 BLAKE            7839 8888                                    
      7782 CLARK            7839 8888                                    
      7566 JONES            7839 8888                                    
      7788 SCOTT            7566 5555                                    
      7902 FORD             7566 5555                                    
      7369 SMITH            7902 7902                                    
      7499 ALLEN            7698 6666                                    
      7521 WARD             7698 6666                                    
      7654 MARTIN           7698 6666                                    
      7844 TURNER           7698 6666                                    

     EMPNO ENAME             MGR CHG_MGR                                 
---------- ---------- ---------- ----------------------------------------
      7876 ADAMS            7788 7777                                    
      7900 JAMES            7698 6666                                    
      7934 MILLER           7782 7777                                    

14개 행이 선택되었습니다. 

 

 

'프로젝트 기반 자바(JAVA) 응용 SW개발자 취업과정' 카테고리의 다른 글

2023-07-04 33일차  (0) 2023.07.04
2023-07-03 32일차  (0) 2023.07.03
2023-06-29 30일차  (0) 2023.06.29
2023-06-28 29일차  (0) 2023.06.28
2023-06-26 27일차  (0) 2023.06.26

+ Recent posts