nls_date_language=american
set NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS
set NLS_LANGUAGE=AMERICAN
set NLS_LANG=AMERICAN.UTF8
@set NLS_LANG=Traditional Chinese_Hong Kong.ZHT16BIG5
@set NLS_LANG=Simplified Chinese_China.ZHS16CGB231280
@set NLS_LANG=Traditional Chinese_Hong Kong.UTF8
@set NLS_LANG=Simplified Chinese_China.UTF8
@set NLS_LANG=Traditional Chinese_Hong Kong.ZHT16BIG5
set NLS_LANG=American_America.UTF8
例：
・日本語（EUC）の場合
unix# setenv LANG 'ja'
unix# setenv LANG 'ja_JP.EUC'
unix# setenv NLS_LANG 'Japanese_Japan.JA16EUC'
・日本語（SJIS）の場合
unix# setenv LANG 'ja_JP.PCK'
unix# setenv LANG 'ja_JP.Shift_JIS'
unix# setenv NLS_LANG 'Japanese_Japan.JA16SJIS'
・日本語（UTF-8）の場合
unix# setenv LANG 'ja_JP.UTF-8'
unix# setenv NLS_LANG 'Japanese_Japan.UTF8'
unix# setenv NLS_LANG 'American_America.UTF8'
・繁体字中国語（Big5）の場合
unix# unset LANG
unix# setenv LANG 'zh_TW.Big5'
unix# setenv NLS_LANG 'Traditional Chinese_Hong Kong.ZHT16BIG5'
・簡体字中国語（GB2312）の場合
unix# unset LANG
unix# setenv LANG 'zh_CN.EUC'
unix# setenv NLS_LANG 'Simplified Chinese_China.ZHS16CGB231280'
===================================
set pagesize 10000
SET SQLBLANKLINES ON
SET SQLBLANKLINES OFF
SET SQLT[ERMINATOR] {;|c|ON|OFF}
set serveroutput on;
set verify off
column segment_name format a25
column segment_type HEADING "Type" format a12
column blocks HEADING "Allocated|Blocks" format 999999999
column Used HEADING "Consumed|Blocks" format 999999999
column p HEADING "Percent|Used" format 999999999
==================================
select sysdate from dual;
===================================
set serveroutput on;
DECLARE
i integer;
begin
i:=1234;
delete from xxx1 where id in (i);
delete from xxx2 where id in (i);
delete from xxx3 where id in (i);
delete from xxx4 where id in (i);
end;
/
DECLARE
i integer;
j integer;
begin
select nvl(id, 999) into i from dual, xxx where id(+)=100000;
if SQL%NOTFOUND THEN
DBMS_OUTPUT.PUT_LINE('SQL%NOTFOUND:
');
END IF;
DBMS_OUTPUT.PUT_LINE('J:
' || i);
end;
/
set serveroutput on;
DECLARE
i integer(10);
begin
i := 0;
XXX(
'001','Remark',i
);
end;
/
BEGIN
DBMS_JOB.CHANGE(
job => 841,
next_date => to_date('22-12-2006 18:00:00','dd-Mm-yyyy HH24:MI:SS'),
interval => 'trunc(decode(sign(to_number(to_char(sysdate,''hh24mi''))-1730),1,sysdate+1,sysdate))+18/24',
what => NULL
);
END;
/
select
trunc(decode(sign(to_number(to_char(sysdate,'hh24mi'))-1730),1,sysdate+1,sysdate))+18/24
from dual;
select
trunc(decode(sign(to_number(to_char(to_date('2006-12-22 17:32','yyyy-mm-dd hh24:mi'),'hh24mi'))-1730),1,sysdate+1,sysdate))+18/24
from dual;
select to_char(sysdate,'hh24mi') from dual;
alter index xxx rebuild unrecoverable;
alter index xxx rebuild;
alter index xxx rebuild tablespace xxx;
UNDO:
AS OF TIMESTAMP (TO_TIMESTAMP('2010-04-07 18:10:00', 'YYYY-MM-DD HH24:MI:SS'))
select status,last_update,update_by from xxx AS OF TIMESTAMP (TO_TIMESTAMP('2010-04-07 18:24:55', 'YYYY-MM-DD HH24:MI:SS')) where id=1234;
