목록DB/Oracle (88)

develog

[Oracle] SYSTIMESTAMP time zone

SYSTIMESTAMP 는 OS time zone을 리턴 SELECT DBTIMEZONE , SESSIONTIMEZONE , TO_CHAR(SYSTIMESTAMP, 'TZH:TZM') SYSTIMESTAMP_TIMEZONEFROM DUAL DBTIMEZONE +00:00SESSIONTIMEZONE +09:00SYSTIMESTAMP TIMEZONE +08:00
DB/Oracle 2016. 2. 3. 10:06
[Oracle] time zone, utc, local time

SELECT SYSTIMESTAMP , TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS TZR') , TO_CHAR(SYS_EXTRACT_UTC(SYSTIMESTAMP), 'YYYY-MM-DD HH24:MI:SS TZR') , TO_CHAR(FROM_TZ(SYS_EXTRACT_UTC(SYSTIMESTAMP), 'UTC') AT TIME ZONE '+08:00', 'YYYY-MM-DD HH24:MI:SS TZR')FROM DUAL
DB/Oracle 2015. 11. 2. 22:54
[Oracle] time zone

SELECT DISTINCT TZNAMEFROM V$TIMEZONE_NAMESWHERE TZNAME LIKE '%Seoul%'; SELECT TZ_OFFSET('Asia/Seoul') FROM DUAL;
DB/Oracle 2015. 11. 2. 19:50
[Oracle] NLS parameter

SELECT *FROM NLS_DATABASE_PARAMETERSORDER BY PARAMETER; SELECT * FROM NLS_SESSION_PARAMETERS ORDER BY PARAMETER; SELECT * FROM NLS_INSTANCE_PARAMETERS ORDER BY PARAMETER;
DB/Oracle 2015. 10. 30. 18:14
[Oracle] 제품 버전 확인

SELECT *FROM PRODUCT_COMPONENT_VERSION;
DB/Oracle 2015. 10. 29. 14:16
[Oracle] DBMS_OUTPUT no limit

DBMS_OUTPUT.ENABLE(BUFFER_SIZE => NULL);DBMS_OUTPUT.ENABLE(NULL); ExceptionsORU-10027: Buffer overflowORU-10028: Line length overflow http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_output.htm
DB/Oracle 2015. 8. 20. 10:38
Prev 1 ··· 3 4 5 6 7 8 9 ··· 15 Next