블로그
-
connect by
SELECT to_char(def.base_date, 'mm-dd') as week FROM (SELECT to_date('20200101', 'yyyy-mm-dd') + (LEVEL - 1) AS base_date FROM dual CONNECT BY LEVEL
blog.naver.com · 2023.01.10
-
oracle에서 mssql 날짜 변환
/* ORACLE SELECT COUNT(*) INTO l_value FROM (SELECT to_date(p_str_dt1, 'YYYY-MM-DD') + LEVEL - 1 AS a_date FROM dual CONNECT BY LEVEL
blog.naver.com · 2022.12.22
-
mssql nextval
BEGIN SELECT ps_doc_id_seq.nextval INTO v_pkid FROM dual; EXCEPTION WHEN no_data_found THEN v_pkid :=
blog.naver.com · 2022.12.20
-
오라클 배우기 : CEIL, FLOOR, ABS, MOD, ROUND, SIGN, TRUNC 함수 & CONCAT, LOWER, UPPER, TRIM, SUBSTRING 함수
EXP(n) 자연상수 e를 n승한 값을 반환 select exp(5) from dual = 148.413 ... 5.
blog.naver.com · 2022.02.17
-
년별 주차 표기
( SELECT trunc(START_DT + LEVEL, 'D') WEEK_START , trunc(START_DT + LEVEL, 'D') + 6 WEEK_END FROM ( SELECT to_date('20210101', 'YYYYMMDD') - 1 START_DT , to_date('20211231', 'YYYYMMDD') END_DT FROM DUAL
blog.naver.com · 2021.08.12
-
구분자로 들어간 멀티데이터 로우로 분할
SELECT REGEXP_SUBSTR(TXT, '[^;]+', 1, LEVEL) TXT FROM (SELECT 'A;B;C;D;E' AS TXT FROM DUAL ) A CONNECT
blog.naver.com · 2020.09.14
-
오라클 날짜,시간차이 구하기(년/개월/일/시/분/초)
to_date(trunc(mod(afterTime - beforeTime, 1)*24*60*60),'SSSSS'),'HH24"시간 "MI"분 "SS"초"') hms --시:분:초 from dual )
blog.naver.com · 2020.05.13
-
Oracle sysdate MySql now()
NOW(6),'%Y%m%d%H%i%S%f') 20자리를 꽉채워서 INSERT UPDATE 했습니다. select DATE_FORMAT(NOW(6),'%Y%m%d%H%i%S%f') from dual; Result = > select DATE_FORMAT(NOW(3),'%Y%m%d%H%i%S%f') from dual; Result = >
blog.naver.com · 2019.02.25
-
오라클 소수점 처리
나머지가 0이 아님') FROM DUAL -- 승수SELECT POWER(3, 2), POWER(3, -2) FROM DUAL; -- 반올림SELECT ROUND(345.123, 0 (345.123, 0), TRUNC(345.123, -1) FROM DUAL; -- POWERSELECT POWER(2, 10) FROM DUAL; - 1024 (2의 10승) --
blog.naver.com · 2018.10.02
-
[연구] 캐나다 레즈비언, 게이, 바이섹슈얼의 정신건강.
investigate whether positive mental health complements mental illness within a theoretically informed (the dual-continua National-level, population-based data from the 2012 Canadian Community Health Survey on Mental Health
blog.naver.com · 2018.09.09
