본문 바로가기

전체 글213

oracle / 암호화 대상칼럼조회 SELECT a.OWNER , A.column_id ,A.TABLE_NAME , A.COLUMN_NAME , C.COMMENTS ,A.DATA_TYPE , A.DATA_LENGTH , A.DATA_PRECISION , A.DATA_SCALE , A.NULLABLE , B.POSITION KEY , A.DATA_DEFAULT , B.CONSTRAINT_NAME , REPLACE(INITCAP(A.COLUMN_NAME),'_') AS CAMELCASE FROM (SELECT * FROM all_tab_columns WHERE 1=1 ) A , (SELECT * FROM all_col_comments WHERE 1=1 ) C , (SELECT X0.OWNER ,X0.TABLE_NAME ,X0.COLUMN_NA.. 2020. 4. 17.
ssh / port 수정 sshd port 수정 [CentOS 6.x] vi /etc/ssh/sshd_config Port 포트번호 service sshd restart 방화벽 해당port추가 vi /etc/sysconfig/iptables -A INPUT -m state –state NEW -m tcp -p tcp –dport 포트번호 -j ACCEPT service iptables restart [CentOS 7.x] vi /etc/ssh/sshd_config ... #Port 22 Port 새로운 포트번호 ... service sshd restart 방화벽 해당port추가 firewall-cmd --permanent --zone=public --add-port=5050/tcp 방화벽 재시작 firewall-cmd --rel.. 2020. 4. 17.
sun / SPARC 2020. 4. 17.
raspberry pi 3 / KODI / pvr / iptv client KODI 18.1 #apt-get install -y kodi #apt-cache search kodi #apt-get install -y kodi-peripheral-joystick kodi-pvr-iptvsimple kodi-inputstream-adaptive kodi-inputstream-rtmp -Kodi on Raspbian requires a minimum of 160 MB of RAM dedicated to the GPU to function properly! This can be done by running "raspi-config" -> "Advanced Options" -> "Memory Split" -> 160. -If you have a RPi 2/3, the recommended.. 2020. 4. 17.
R / rstudio / 개발환경설정 1. R 설치 https://www.r-project.org/ https://cran.r-project.org/mirrors.html Korea https://ftp.harukasan.org/CRAN/ Information and Database Systems Laboratory, Pukyong National University https://cran.yu.ac.kr/ Yeungnam University https://cran.seoul.go.kr/ Bigdata Campus, Seoul Metropolitan Govermment http://healthstat.snu.ac.kr/CRAN/ Graduate School of Public Health, Seoul National University, Se.. 2020. 4. 16.
R / example 2020. 4. 16.
windows / CLI / schtasks / backup / script @echo off rem 날짜포멧만 가지고 변수로 저장 YYYYMMDD형식으로 rem rem 아래 형식으로 스케줄에 등록 rem schtasks /create /tn "fb_book_backup_everyday" /tr C:\data\backup.bat /sc daily /st 03:00:00 /sd 2006/01/01 rem rem 스케줄 삭제 rem schtasks /delete /tn "fb_book_backup_everyday" rem rem setlocal enableextensions set arcname=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2% "C:\Program Files\Firebird\Firebird_2_0.. 2020. 4. 16.
windows / CLI / pdf command print "C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe" /t /h "c:\temp\1.pdf" "FX DocuPrint CM115/118 w" 2020. 4. 16.
LG-V520 / APN LG-V520 APN : ltetab.sktelecom.com 2020. 4. 16.
반응형

티스토리툴바