혼자놀기

Gap in Primes The prime numbers are not regularly spaced. For example from 2 to 3 the gap is 1. From 3 to 5 the gap is 2. From 7 to 11 it is 4. Between 2 and 50 we have the following pairs of 2-gaps primes: 3-5, 5-7, 11-13, 17-19, 29-31, 41-43 A prime gap of length n is a run of n-1 consecutive composite numbers between two successive primes (see: http://mathworld.wolfram.com/PrimeGaps.html). We..

Directions Reduction Once upon a time, on a way through the old wild west, a man was given directions to go from one point to another. The directions were "NORTH", "SOUTH", "WEST", "EAST". Clearly "NORTH" and "SOUTH" are opposite, "WEST" and "EAST" too. Going to one direction and coming back the opposite direction is a needless effort. Since this is the wild west, with dreadfull weather and not ..

Stop gninnipS My sdroW! Write a function that takes in a string of one or more words, and returns the same string, but with all five or more letter words reversed (Just like the name of this Kata). Strings passed in will consist of only letters and spaces. Spaces will be included only when more than one word is present. Examples: spinWords( "Hey fellow warriors" ) => returns "Hey wollef sroirraw..

Checking Groups In English and programming, groups can be made using symbols such as () and {} that change meaning. However, these groups must be closed in the correct order to maintain correct syntax. Your job in this kata will be to make a program that checks a string for correct grouping. For instance, the following groups are done correctly: ({}) [[]()] [{()}] The next are done incorrectly: ..

Decode the Morse code In this kata you have to write a simple Morse code decoder. While the Morse code is now mostly superceded by voice and digital data communication channels, it still has its use in some applications around the world. The Morse code encodes every character as a sequence of "dots" and "dashes". For example, the letter A is coded as ·−, letter Q is coded as −−·−, and digit 1 is..

Weight for weight My friend John and I are members of the "Fat to Fit Club (FFC)". John is worried because each month a list with the weights of members is published and each month he is the last on the list which means he is the heaviest. I am the one who establishes the list so I told him: "Don't worry any more, I will modify the order of the list". It was decided to attribute a "weight" to nu..

새로운 계정 만들기 1단계) DBA 접속 ID : system PWD : manager ID : sys PWD : sys 2단계 ) 개인계정 1) 다른 사용자 - 사용자생성 기본 테이블스페이스 users 임시 테이블스페이스 temp 2) 부여된 롤에서 connect resource 선택 3)시스템 권한 create any view drop any view 선택 4) 적용 (여러문장일경우 다 선택해서 해야함) 5 select * (all) distinct 열이름, 집단함수 sum(열이름), avg(열이름), max(열이름), min(열이름), count(열이름) 1 from 테이블 2 where 레코드에 제한을 가할 때 열이름 연산자 비교값,열이름....부속질의(subquery) 열이름 in (값,,,,,..

출처 : https://kldp.org/node/102947

1. Sub Query에 Alies는 필수 2. Sub Query 내에 ORDER BY 절을 사용할 수 없음 3. NVL 함수는 ISNULL로 대체 4. SUBSTR 함수는 SUBSTRING으로 대체 5. 문자열 연결 ||는 +로 대체 6. TRIM 함수는 LTRIM(RTRIM(FieldName))으로 대체 7. STDDEV 함수는 STDEV로 대체 8. CEIL 함수는 CEILING으로 대체 9. ROWNUM - ORDER BY 절 없이 WHERE 절에서 ROWNUM = 1 사용 시 SELECT 절에서 Top1으로 대체 - ORDER BY 절 사용 시, SELECT 절에 ROWNUMBER() OVER (ORDER BY Field1...FieldN) 으로 대체 10. MOD 함수는 %로 대체 예) ORA..

JAVA ● 자바 기반 응용프로그래밍 개발 기술 습득 ● 네트워크 모델의 이해와 protocol 설계를 통한 다자간 채팅, 네트워크 등을 작성 - soket을 이용한 채팅프로그램 구현 - 소켓을 이용한 통신 프로그래밍을 뜻한다. - 소켓(Socket) : 프로세스 간의 통신에 사용되는 양쪽 끝단을 의미한다. - java.net 패키지를 통해 소켓프로그래밍을 지원한다. TCP와 UDP를 이용한 소켓프로그래밍이 대표적이다. ● JDBC CRUD 작업을 통한 데이터의 효율적 관리능력 습득 - JDBC (Java Database Connectivity) CRUD(CREATE, READ, UPDATE, DELETE) - Java에서 DB에 접근하여 데이터 조회, 삽입, 수정, 삭제를 가능케하는 것(connecti..