노마드오브

package test; import java.util.HashMap;import java.util.Map;import java.util.Scanner; public class Test2 { public static void main(String[] args) {Scanner scanner = new Scanner(System.in);Map map = new HashMap(); System.out.println("나라이름과 인구를 입력하세요(예: Korea 5000)"); while (true) {System.out.print("나라이름, 인구 >> ");String contryName = scanner.next();if (contryName.equals("그만")) {break; // 입력 중지} in..

package test; import java.util.List;import java.util.Scanner;import java.util.Vector; public class Test1 { public static void main(String[] args) { List rainlist = new Vector(); Scanner scanner = new Scanner(System.in);while (true) {System.out.println("강수량 입력 (0 입력시 종료) >> ");int num = scanner.nextInt(); if (num == 0) {System.out.println("종료합니다");break;} int sum = 0;rainlist.add(num);for (int i=..

package test2; import java.util.ArrayList;import java.util.Iterator;import java.util.List;import java.util.Scanner; class Person {private String name;private int age;private String address;public Person(String name, int age, String address) {super();this.name = name;this.age = age;this.address = address;}// getter & setterpublic String getName() {return name;}public void setName(String name) {th..

package test; import java.util.ArrayList;import java.util.Iterator;import java.util.List;import java.util.Scanner;import java.util.Vector; class Person {String name;int age;String address;public Person(String name, int age, String address) {super();this.name = name;this.age = age;this.address = address;}// getter & setterpublic String getName() {return name;}public void setName(String name) {thi..

package test; import java.util.ArrayList;import java.util.Iterator;import java.util.List;import java.util.Scanner; public class Test8 { public static void main(String[] args) {// 이름 5개를 입력받아서 리스트에 저장하고// 그 이름을 순서대로 출력하기List list = new ArrayList(5);final int count = 5;Scanner scanner = new Scanner(System.in);String name;for (int i=0; i

-- 커서 사용, declare, open, fetch, closeset serverout on;declare vempid employees.employee_id%type; vfname employees.first_name%type; cursor cl is -- 커서 정의, 여러 레코드를 가질 수 있다 select employee_id, first_name from employees where department_id= 30;begin open cl; -- 커서 열기 loop fetch cl into vempid, vfname; -- 커서 cl의 값을 vempid, vfname에 각각 담기 exit when cl%notfound; -- 커서 cl에 더이상 레코드가 없으면 loop종료 dbms_output..

-- as뒤의 select문에 해당하는 내용으로 pl_employees3라는 테이블 만들기create table pl_employees3asselect employee_id, first_name, salaryfrom employees; -- pl_employees3 테이블 조회select * from pl_employees3; -- 조회된 컬럼 하나씩 변수에 담기set serveroutput on -- 화면에 출력declare vno pl_emloyees3.employee_id%type; -- pl_emloyees3.employee_id의 데이터타입으로 vno 변수 생성 vname pl_employees3.first_name%type; vsal pl_employees3.salary%type;begin s..

* 계정비밀번호 변경 및 unlock 커맨드창 열기sqlplus 엔터sys as sysdba 엔터비밀번호입력 엔터 alter user hr account unlock;alter user hr identified by hr;commit;

SELECT CUSTID, (SELECT ADDRESS FROM CUSTOMER CS WHERE CS.CUSTID = OD.CUSTID) "ADDRESS", SUM(OD.SALEPRICE) "TOTAL"FROM ORDERS ODGROUP BY OD.CUSTID; SELECT CS.NAME, SFROM (SELECT CUSTID, AVG(SALEPRICE) S FROM ORDERS GROUP BY CUSTID) OD, CUSTOMER CSWHERE CS.CUSTID=OD.CUSTID; CREATE VIEW VW_CUSTOMERAS SELECT * FROM CUSTOMER WHERE ADDRESS LIKE '%대한민국%'; SELECT * FROM VW_CUSTOMER; CREATE VIEW HIGHORDE..

DROP USER madang CASCADE;CREATE USER madang IDENTIFIED BY madang DEFAULT TABLESPACE users TEMPORARYTABLESPACE temp PROFILE DEFAULT; GRANT CONNECT, RESOURCE TO madang;GRANT CREATE VIEW, CREATE SYNONYM TO madang; ALTER USER madang ACCOUNT UNLOCK; /* 여기서부터는 마당 계정으로 접속 */conn madang/madang; CREATE TABLE Book ( bookid NUMBER(2) PRIMARY KEY, bookname VARCHAR2(40), publisher VARCHAR2(40), price NUMBER(..