문서작성 번호순서

Board 2018.08.28 10:38 Posted by 애플자라

1.
 
가.
    
1)
       
가)
           
(1)
              
(가)

                  ①

                     ㉮

                 


                     

 

'Board' 카테고리의 다른 글

문서작성 번호순서  (0) 2018.08.28
[직구]Shirts 사이즈  (0) 2018.03.09
[SKT]일본로밍서비스정보  (0) 2017.12.01
[명함관리]REMEMBER  (0) 2017.10.26
[EXCEL]SUMIF, SUMIFS  (0) 2017.10.18
[민원24]주민등록표등본교부신청  (0) 2017.10.12

램디스크 (Softperfect RamDisk)

Tips 2018.07.18 15:06 Posted by 애플자라

 

사용방법


1. + 버튼을 눌러주자.

2. 크기에 원하는 만큼의 램 용량을 넣어주자. (자신의 램 용량이 8기가라면 1기가, 16기가라면 2~3기가를 넣어도 좋다. 필자는 32기가라 10기가를 넣었다.)

3. 드라이브 문자를 정해주자. X Y Z 아무거나 써도 좋다.

4. 파일시스템은 NTFS 로 해주자. 아무래도 현재 윈도우에서 사용되는 포맷과 맞춰주는게 좋다.

5. 폴더 생성 부분에는 위 그림처럼 폴더별로 한줄씩 적어주면된다. 부팅시에 그대로 폴더가 생성된다.


생성 끝.


필자는 위 사진이랑은 다르게 Y 드라이브로 마운트 했다.

 

 

ramdisk_setup_3.4.7.exe

 

**** 주의 *****

램디스크라는건 휘발성 램에 데이터를 쓴다는 이야기이다. 즉 재부팅하면 날라가는 부분이라는것.

임시로 사용되는 데이터만 기록할 때 쓰는것이다. 대신 속도가 굉장히 빠르다.


출처: http://haru.kafra.kr/76 [어제도 오늘도 내일도 언제나 하루]

[ORACLE]ROW_NUMBER 순서

Database 2018.07.03 08:29 Posted by 애플자라
SELECT 
   ROW_NUMBER() OVER (ORDER BY NAME ASC) AS EMS_M_ID,
   NAME AS EMS_M_NAME,
   TRIM(REPLACE(MOBILE,'-','')) AS EMS_M_PHONE
FROM APLUSORA.TEMP_N_BOARD_EVENT
ORDER BY NAME ASC

 

'Database' 카테고리의 다른 글

[ORACLE]ROW_NUMBER 순서  (0) 2018.07.03
[Oracle] 누적접수건수  (0) 2018.06.27
[Oracle] 다중 LIKE(REGEXP_LIKE)  (0) 2018.06.12
[ORACLE]COUNT DECODE  (0) 2018.06.04
[ORACLE]WMSYS.WM_CONCAT 월별데이터 합치기  (0) 2018.04.06
[ORACLE]그룹함수로 중복된 컬럼 제거하기  (0) 2017.11.08

[Oracle] 누적접수건수

Database 2018.06.27 17:41 Posted by 애플자라

SELECT TO_CHAR (REG_DATE, 'YYYY-MM-DD') AS "접수일",
   COUNT (1) "접수건수",
   SUM (COUNT (1)) OVER (ORDER BY TO_CHAR (REG_DATE, 'YYYY-MM-DD')) "누적접수건수"
FROM N_BOARD_EVENT
GROUP BY TO_CHAR (REG_DATE, 'YYYY-MM-DD')
ORDER BY TO_CHAR (REG_DATE, 'YYYY-MM-DD')

 

'Database' 카테고리의 다른 글

[ORACLE]ROW_NUMBER 순서  (0) 2018.07.03
[Oracle] 누적접수건수  (0) 2018.06.27
[Oracle] 다중 LIKE(REGEXP_LIKE)  (0) 2018.06.12
[ORACLE]COUNT DECODE  (0) 2018.06.04
[ORACLE]WMSYS.WM_CONCAT 월별데이터 합치기  (0) 2018.04.06
[ORACLE]그룹함수로 중복된 컬럼 제거하기  (0) 2017.11.08

[Oracle] 다중 LIKE(REGEXP_LIKE)

Database 2018.06.12 08:13 Posted by 애플자라
EDIT EM_MMT_LOG_201806
WHERE TRAN_ETC2='MASS'
AND REGEXP_LIKE(TRAN_ETC1, '2018060800001|2018061100001|2018061100002')
--AND TRAN_ETC1 (LIKE '%2018060800001%' or LIKE '%2018061100001%' or LIKE '%2018061100002%')

 

'Database' 카테고리의 다른 글

[ORACLE]ROW_NUMBER 순서  (0) 2018.07.03
[Oracle] 누적접수건수  (0) 2018.06.27
[Oracle] 다중 LIKE(REGEXP_LIKE)  (0) 2018.06.12
[ORACLE]COUNT DECODE  (0) 2018.06.04
[ORACLE]WMSYS.WM_CONCAT 월별데이터 합치기  (0) 2018.04.06
[ORACLE]그룹함수로 중복된 컬럼 제거하기  (0) 2017.11.08

[ORACLE]COUNT DECODE

Database 2018.06.04 09:23 Posted by 애플자라

SELECT '신청: '||TOTAL||'건(전체), '||P_TYPE||'건(PC), '||M_TYPE||'건(모바일)' AS EVENT_M

FROM

(

SELECT COUNT (1) AS TOTAL,

       COUNT (DECODE (TYPE, 'P', 'P')) AS P_TYPE,

       COUNT (DECODE (TYPE, 'M', 'M')) AS M_TYPE

  FROM N_BOARD_EVENT

)

[ORACLE]WMSYS.WM_CONCAT 월별데이터 합치기

Database 2018.04.06 09:17 Posted by 애플자라

SELECT 
    GROUP_NAME,
    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_01),',','<br/>'),'(Meeting)','') AS DATE_01,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_02),',','<br/>'),'(Meeting)','') AS DATE_02,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_03),',','<br/>'),'(Meeting)','') AS DATE_03,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_04),',','<br/>'),'(Meeting)','') AS DATE_04,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_05),',','<br/>'),'(Meeting)','') AS DATE_05,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_06),',','<br/>'),'(Meeting)','') AS DATE_06,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_07),',','<br/>'),'(Meeting)','') AS DATE_07,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_08),',','<br/>'),'(Meeting)','') AS DATE_08,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_09),',','<br/>'),'(Meeting)','') AS DATE_09,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_10),',','<br/>'),'(Meeting)','') AS DATE_10,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_11),',','<br/>'),'(Meeting)','') AS DATE_11,

    REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_12),',','<br/>'),'(Meeting)','') AS DATE_12

FROM (SELECT GROUP_NAME,
       MARKETING_DATE,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '01' THEN MARKETING_DATE END MARKETING_DATE_01,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '02' THEN MARKETING_DATE END MARKETING_DATE_02,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '03' THEN MARKETING_DATE END MARKETING_DATE_03,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '04' THEN MARKETING_DATE END MARKETING_DATE_04,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '05' THEN MARKETING_DATE END MARKETING_DATE_05,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '06' THEN MARKETING_DATE END MARKETING_DATE_06,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '07' THEN MARKETING_DATE END MARKETING_DATE_07,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '08' THEN MARKETING_DATE END MARKETING_DATE_08,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '09' THEN MARKETING_DATE END MARKETING_DATE_09,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '10' THEN MARKETING_DATE END MARKETING_DATE_10,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '11' THEN MARKETING_DATE END MARKETING_DATE_11,
       CASE WHEN SUBSTR (MARKETING_DATE, 6, 2) = '12' THEN MARKETING_DATE END MARKETING_DATE_12,
       ROW_NUMBER () OVER (PARTITION BY GROUP_NAME ORDER BY MARKETING_DATE) RNUM
  FROM TB_MARKETING
 WHERE     SUBSTR (MARKETING_DATE, 0, 4) = '2018'
       --AND GROUP_NAME = '건설기술용역공제조합' 
     )
START WITH RNUM = 1
CONNECT BY PRIOR RNUM = RNUM - 1 AND PRIOR GROUP_NAME = GROUP_NAME
GROUP BY GROUP_NAME
ORDER BY GROUP_NAME ASC

 

출처 - http://blog.naver.com/PostView.nhn?blogId=jaejin1028&logNo=220793468335 

 

[직구]Shirts 사이즈

Board 2018.03.09 10:53 Posted by 애플자라



'Board' 카테고리의 다른 글

문서작성 번호순서  (0) 2018.08.28
[직구]Shirts 사이즈  (0) 2018.03.09
[SKT]일본로밍서비스정보  (0) 2017.12.01
[명함관리]REMEMBER  (0) 2017.10.26
[EXCEL]SUMIF, SUMIFS  (0) 2017.10.18
[민원24]주민등록표등본교부신청  (0) 2017.10.12

[Linux]yum CentOS 지난 버전 사용하기

Linux 2017.12.20 15:12 Posted by 애플자라

대략 지난 버전이 꼭 필요하다면 http://vault.centos.org를 이용하라는 소리다.

http://vault.centos.org에 가보면 지난 디렉토리들이 보이고, 디렉토리에 들어가면 다른 미러와 다르게 여러 디렉토리들이 보인다.

 

-------------------------------------------------------------------------

 

버전확인 ------>

grep . /etc/*-release
cat /etc/*-release | uniq

 

-------------------------------------------------------------------------

 

 

경로 : /etc/yum.repos.d

 

# CentOS-Base.repo
#
# The mirror system uses the connecting IP address of the client and the
# update status of each mirror to pick mirrors that are updated to and
# geographically close to the client. You should use this for CentOS updates
# unless you are manually picking other mirrors.
#
# If the mirrorlist= does not work for you, as a fall back you can try the
# remarked out baseurl= line instead.
#
#

 


[base]
name=CentOS-$releasever - Base
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
#baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/
baseurl=http://vault.centos.org/5.5/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5


#released updates
[updates]
name=CentOS-$releasever - Updates
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates
#baseurl=http://mirror.centos.org/centos/$releasever/updates/$basearch/
baseurl=http://vault.centos.org/5.5/updates/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5


#additional packages that may be useful
[extras]
name=CentOS-$releasever - Extras
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras
#baseurl=http://mirror.centos.org/centos/$releasever/extras/$basearch/
baseurl=http://vault.centos.org/5.5/extras/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5


#additional packages that extend functionality of existing packages
[centosplus]
name=CentOS-$releasever - Plus
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus
#baseurl=http://mirror.centos.org/centos/$releasever/centosplus/$basearch/
baseurl=http://vault.centos.org/5.5/centosplus/$basearch/
gpgcheck=1
enabled=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5


#contrib - packages by Centos Users
[contrib]
name=CentOS-$releasever - Contrib
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=contrib
#baseurl=http://mirror.centos.org/centos/$releasever/contrib/$basearch/
baseurl=http://mirror.centos.org/centos/6.5/contrib/$basearch/
gpgcheck=1
enabled=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

 

-------------------------------------------------------------------------

저장하고

 

>yum clean all
>yum repolist

 

해서 제대로 동작하는지 확인한다.

 

출처 - http://nojinho.blogspot.kr/2015/06/tip-centos-iso-yum-repository.html

 

'Linux' 카테고리의 다른 글

[Linux]yum CentOS 지난 버전 사용하기  (0) 2017.12.20
[Linux]mount nfs 에러  (0) 2017.11.15
[FTP]SecureCrt X/Y/Zmodem  (0) 2017.09.18
[Linux]batch shell(tar,ftp,sftp)  (0) 2017.08.08
[SSH]접속툴(telnet/SSH/SFTP)  (0) 2017.08.03
[Linux]Samba 업데이트  (0) 2017.06.13

[SKT]일본로밍서비스정보

Board 2017.12.01 10:54 Posted by 애플자라

 

'Board' 카테고리의 다른 글

문서작성 번호순서  (0) 2018.08.28
[직구]Shirts 사이즈  (0) 2018.03.09
[SKT]일본로밍서비스정보  (0) 2017.12.01
[명함관리]REMEMBER  (0) 2017.10.26
[EXCEL]SUMIF, SUMIFS  (0) 2017.10.18
[민원24]주민등록표등본교부신청  (0) 2017.10.12