헤르메스 LIFE

참고 : http://tylee82.tistory.com/116 export를 실행하는데 아래와 같은 에러가 발생하였다. [oracle@CentOS5DBserver ~]$ exp ID/pwass@TEST_SERVERfile=TESTDB090617.dmp log=TESTDB090617.log Export: Release 9.2.0.4.0 - Production on Tue Jun 16 09:24:42 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP ..

상황 SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for 64-bit Windows: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production Oracle 11g 에서 Export 받은 파일을 Oracle XE 11.2..

달력 쿼리 셈플 WITH CALENDAR AS ( SELECT CEIL((T1.RNUM + 7 - TO_NUMBER(TO_CHAR(TO_DATE('201606' || LPAD(TO_CHAR(T1.RNUM), 2, '0'), 'YYYYMMDD'), 'D'))) / 7) WOM, TO_CHAR(TO_DATE('201606' || LPAD(TO_CHAR(T1.RNUM), 2, '0'), 'YYYYMMDD'), 'D') DOW, '201606' || LPAD(TO_CHAR(T1.RNUM), 2, '0') CAL_YMD, T1.RNUM DOM FROM (SELECT ROWNUM RNUM FROM ALL_OBJECTS WHERE ROWNUM = LTRIM(TO_CHAR(T1.RNUM, '00')) ) SELECT ..

연속된 날짜 생성 쿼리 -- 시작일('20130101'), 종료일('20130110') SELECT TO_DATE('20111201', 'YYYY-MM-DD') + LEVEL - 1 AS DATES FROM DUAL CONNECT BY LEVEL

중복기간 체크 SELECT CASE WHEN EXISTS ( SELECT 1 FROM CHECK_TABLE WHERE KEY0 = 'KEY0' AND KEY1 = 'KEY1' AND STA_YMD '시작일' AND STA_YMD = '시작일' ) THEN 'Y' ELSE 'N' END DUP_YN FROM DUAL

-- 전일 SELECT TO_CHAR(SYSDATE - 1, 'YYYYMMDD') FROM DUAL; -- 현재주 SELECT TO_CHAR(SYSDATE, 'WW') FROM DUAL; -- 지난주 SELECT TO_CHAR(SYSDATE -7, 'WW') FROM DUAL; -- 현재월 SELECT TO_CHAR(SYSDATE, 'YYYYMM') FROM DUAL; -- 현재분기 SELECT TO_CHAR(SYSDATE, 'q') FROM DUAL; -- 반기 SELECT CEIL(TO_CHAR(SYSDATE, 'q') / 2) FROM DUAL;

출처 : http://ora-sysdba.tistory.com/entry/MariaDB-Maria-DB-%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4-%EC%83%9D%EC%84%B1-%EA%B6%8C%ED%95%9C-%EB%B6%80%EC%97%AC-%EC%A0%91%EC%86%8D Create Maria Database 아래와 같은 방법으로 데이터베이스를 생성합니다. # /usr/local/mysql/bin/mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 5.5.30-MariaDB-log Sourc..

출처 : http://ora-sysdba.tistory.com/category/MariaDB%20Admin%20Guide/Install%20How%20To How to Install MariaDB Server 10 by using yum 서버 구성환경Virtual Machine VMware Workstation 10.0.0OS Cent OS 7.0Devices Memory : 1 GB Processors : 1 Hard Disk(SCSI) : 10 GB Network Adapter : NAT DB Link Download MariaDB MariaDB Server 10 버전을 CentOS 7에 yum 패키지를 사용하여 설치하는 방법을 알아보겠습니다. Create MariaDB yum repo file각 O..

출처 : http://articles.slicehost.com/2009/4/7/centos-installing-mysql-with-rails-and-php-options Installing MySQL on CentOS is very simple using the 'yum' package manager.This article will go through the install process and also look at what other packages are needed for MySQL to integrate with Ruby on Rails and with a standard PHP install.MySQL InstallTo begin with, a simple MySQL install:sudo yu..

출처 : http://www.mysqlkorea.com/gnuboard4/bbs/board.php?bo_table=develop_03&wr_id=67 - MariaDB (http://mariadb.com) - (1) 소개 MySQL 개발자 미카엘 위데니우스에 의해 만들어진 MariaDB는 MySQL이 MariaDB의 모태이며, Sun에서 가져온 DataBase입니다. 그러므로 MySQL과 흡사합니다. (2) MariaDB 다운로드 https://downloads.mariadb.org/mariadb/repositories/ (3) 설치 컴파일버전이 아닌 보다 high performance인 바이너리버전(64bit)으로 설치하겠습니다. OS = CentOS 5.4MariaDB버전 = mariadb-5.1.4..