Programmer's Note

python설치http://xprogrammer.tistory.com/330 Django설치pip install django JDK 설치http://www.oracle.com/technetwork/java/javase/overview/index.html 이클립스다운로드http://www.eclipse.org/downloads/ 이클립스플러그인설치(pyDev)pyDev 이클립스플러그인환경설정Preferences > PyDev > Interpreters > Python Interpreters > Quick Auto-Config 프로젝트생성File > New > Other > PyDev > PyDev Django Project

가상환경생성C:\Work\Djangopython -m venv myvenv 가상환경실행C:\Work\Django\myvenv\Scripts\activate Django설치pip install django 사이트생성django-admin startproject mysite . 환경설정C:\Work\Django\mysite\settings.pyTIME_ZONE = 'Asia/Seoul' 서버실행python manage.py runserver 확인http://127.0.0.1:8000

설치시작메뉴 > 실행 > cmdpip install jupyteripython profile create 환경설정C:\Users\계정이름\.ipython\profile_default\ipython_config.pyc.InteractiveShellApp.matplotlib = 'inline'c.InteractiveShellApp.pylab = 'inline' 작업을 저장할 폴더 만들기C:\Work\Jupyter 실행시작메뉴 > 실행 > cmdcd C:\Work\Jupyterjupyter notebook

스키마http://xprogrammer.tistory.com/333 쿼리 WITH TEMP AS ( SELECT ENAME, SAL, COMM -- 데이터영역에 표시할 컬럼명 FROM EMP ) SELECT ENAME, COL, -- 데이터영역의 컬럼헤더 DATA -- 데이터영역의 컬럼헤더 FROM TEMP UNPIVOT( DATA -- 데이터영역의 컬럼헤더 FOR COL -- 컬럼영역의 컬럼헤더 IN (SAL, COMM) -- 데이터영역에 표시할 컬럼명 ); 결과 테스트http://sqlfiddle.com

스키마 http://xprogrammer.tistory.com/333 쿼리 WITH TEMP AS ( SELECT DEPTNO, SAL FROM EMP ) SELECT * FROM TEMP PIVOT( SUM(SAL) -- 그룹핑할 대상 (GROUP 함수) FOR DEPTNO -- 피봇의 기준 (GROUP BY) IN (10, 20, 30) -- 필터링 ); 결과 테스트 http://sqlfiddle.com

CREATE TABLE EMP( EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2) ); INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-12-1980', 'DD-MM-YYYY'), 800, NULL, 20); INSERT INTO EMP VALUES (7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('20-02-1981', 'DD-MM-YYYY'), 1600, 300, 30); INSERT INTO E..

DDL (Data Definition Language): 데이터 정의CREATEALTERDROPRENAMETRUNCATECOMMENT QUERY: 데이터 조회SELECT DML (Data Manipulation Language): 데이터 조작INSERTUPDATEDELETE TCL (Transaction Control Language): 트랜젝션 제어COMMITROLLBACKSAVEPOINT DCL (Data Control Language): 데이터 제어GRANTREVOKE

JS추가 코드추가 $(window).load(function() { $("#content .article pre[class]").each(function() { try{ var lang = String($(this).attr("class")).match(/brush\:([ a-zA-Z_]*)\;?/)[1]; lang = lang.trim().replace(/^js$/i, "javascript"); var editor = ace.edit(this); editor.getSession().setMode("ace/mode/"+ lang);// 언어설정 editor.setTheme("ace/theme/pastel_on_dark"); // 테마설정 editor.setReadOnly(true);// 읽기전용설정 ed..

다운로드https://www.python.org/downloads/release/python-362/https://www.python.org/downloads/release/python-2714/ 설치

[입문]Oracle Database: Introduction to SQLIntroduction to Oracle Database 1Introduction to Oracle Database 2Retrieve Data using the SQL SELECT Statement 1Retrieve Data using the SQL SELECT Statement 2Learn to Restrict and Sort Data 1Learn to Restrict and Sort Data 2Usage of Single-Row Functions to Customize OutputInvoke Conversion Functions and Conditional Expressions 1Invoke Conversion Functions ..