본문 바로가기
반응형

전체 글273

oracle 달력 sql oracle 달력 sql select sun, mon, tue, wed, thu, fri, sat from ( select week, max(decode(dat, 1, day)) as sun, max(decode(dat, 2, day)) as mon, max(decode(dat, 3, day)) as tue, max(decode(dat, 4, day)) as wed, max(decode(dat, 5, day)) as thu, max(decode(dat, 6, day)) as fri, max(decode(dat, 7, day)) as sat from ( select to_char(dates, 'DD') as day, to_char(dates, 'D') as dat, to_char(dates, 'D') - .. 2022. 7. 8.
Oracle Prodedure synchronized (lock) 오라클에서 프로시저에도 자바의 SYNCHRONIZED 처럼 락을 설정할수있다! DECLARE -- lock 처리 LOCKHANDLE VARCHAR2(128); RETCODE NUMBER; BEGIN DBMS_LOCK.ALLOCATE_UNIQUE('WaveOrderSelectionLock', LOCKHANDLE); RETCODE := DBMS_LOCK.REQUEST(LOCKHANDLE, TIMEOUT => 0, LOCKMODE => DBMS_LOCK.X_MODE); IF RETCODE 0 THEN O_ERR_CD := 'MSG_00289'; RAISE E_EXCEPTION; END IF; RETCODE := DBMS_LOCK.RELEASE(LOCKHANDLE); END; 출처: https://nitroba.. 2022. 6. 3.
table 권한 조회 grant select, update, delete on 테이블 to 유저; revoke select, update, delete on 테이블 from 유저; oracle select * from user_tab_privs mssql select * from information_schema.table_privileges 2022. 2. 11.
iperf iperf 네트워크로 얼마나 데이터를 받고 보낼 수 있는지를 측정할 수 있는 툴로서 가장 안정적인 툴 다운로드 https://iperf.fr/iperf-download.php iPerf - Download iPerf3 and original iPerf pre-compiled binaries iPerf - The ultimate speed test tool for TCP, UDP and SCTPTest the limits of your network + Internet neutrality test Table of contents : Download iPerf for Windows Download iPerf3 for Android Download iPerf3 for iPhone / iPad Download .. 2022. 2. 8.
Oralce rollup, cube, grouping sets Oralce rollup, cube, grouping sets 오라클 rollup, cube, grouping sets, 컬럼추출 그룹화 사용법&예제 by codecow 2020. 11. 12. 오라클의 rollup, cube 함수는 group by와 함께 사용하는 옵션입니다. rollup : 첫 번째 컬럼의 집계 결과를 추출 cube : 모든 컬럼의 집계 결과를 추출 직책별, 성별 인원수를 추출하겠습니다. select sajob, gender, count(*) from sawon group by rollup(sajob, gender); 위처럼 group by에 rollup을 사용하게 되면, 직책별 성별, 직책별, 전체 인원수를 집계해줍니다. 성별 인원수까지 집계하려면 cube를 사용하면 됩니다. sel.. 2022. 2. 4.
Windows PowerShell WMI Query Windows PowerShell WMI Query c:\wbemtest.exe 연결 - 쿼리 Get-CimInstance -Query 'Select * from win32_processor' Get-CimInstance -Query 'Select * from win32_operatingsystem' Get-CimInstance -Query 'Select * from win32_computersystem' Get-CimInstance -Query 'Select * from Win32_PhysicalMemory' Get-CimInstance -Query 'Select * from Win32_BIOS' Get-CimInstance -Query 'Select * from Win32_DiskDrive' Get-.. 2022. 1. 7.
Don't Sleep Don't Sleep 윈도우의 슬립 기능 차단 (절전모드, 모니터끄기, 화면보호기, 시스템종료 등) 키, 마우스, 데이터사용량 등으로 설정 가능 프리웨어 Don't Sleep is a small Freeware Windows program to prevent system shutdown, Standby, Hibernate, Turn Off and Restart. Especially when old Programs run on Windows 10, 8.1, ... . Here's more aggressive power-saving features with new rules. But not only that, it also prevents login off the computer, and the deacti.. 2021. 12. 28.
SCOUTER 스카우터 모니터링 툴 (os, java, sql ...) https://github.com/scouter-project/scouter GitHub - scouter-project/scouter: Scouter is an open source APM (Application Performance Management) tool. Scouter is an open source APM (Application Performance Management) tool. - GitHub - scouter-project/scouter: Scouter is an open source APM (Application Performance Management) tool. github.com SCOUTER 간단 사용설명서 scouter ove.. 2021. 11. 26.
oracle 정규식 REGEXP Oracle 10g에서는 REGEXP_로 시작하는 함수를 지원합니다. 레귤러 익스프레션 지원이죠. 아래는 그 함수들의 사용방법을 공유합니다. 1. REGEXP_INSTR 함수 - 문법 : REGEXP_INSTR(소스 문자열, Pattern [, 검색 시작 위치 [, 발생 횟수 [, 반환 옵션 [, Match를 시도할 때의 옵션]]]]) - 예제 1 2 3 4 5 6 SELECT REGEXP_INSTR('Regular Expression', 'a') REG_INS FROM dual; REG_INS ---------- 6 2. REGEXP_LIKE - 문법 : REGEXP_LIKE(소스 문자열, Pattern [, Match를 시도할 때의 옵션]) - [[:digit:]] : 숫자인것 - [^[:digit:.. 2021. 11. 10.
FTP From PL/SQL FTP From PL/SQL Sometimes it's preferable to trigger FTP jobs directly from PL/SQL rather than rely on CRON or AT. This article contains a brief description of the two methods I use. Shell Script PL/SQL FTP API ACL for 11g SFTP and FTPS Shell Script The first method relies on a java stored procedure, described in Shell Commands From PL/SQL, which can be used to trigger a shell script to perform .. 2021. 7. 14.
반응형

티스토리툴바