Oracle

//作成
GRANT CREATE ANY TABLE TO TEST_USER;
GRANT CREATE ANY TABLE TO TEST_USER;
//挿入
GRANT INSERT ANY ...

Oracle

SQL構文

SELECT TO_CHAR( SYSDATE , 'EEYY"年"MM"月"DD"日"' , 'NLS_CALENDAR=''JAPANESE IMPERIAL''' ) AS "EEYY年MM月DD日" , TO ...

Oracle

1.パラメータ audit_trailの変更
SQL> ALTER SYSTEM SET audit_trail = none scope = spfile;

2.Oracleを再起動
SQL> ...

Oracle

SQL構文

DECLARE TYPE CFT_USER_TYPE IS RECORD ( USERNO NUMBER NOT NULL DEFAULT 21, USERNAME VARCHAR2(10), ADDRESS VAR ...

Oracle

書式
NET_SERVICE_NAME=
( DESCRIPTION=
( ADDRESS=(PROTOCOL_ADDRESS_PORT))
( CONNECT_DATA= (SERVICE_NAME= ...

Oracle

SQL構文下記

1.ROLEUSERを作成CREATE ROLE ROLEUSER;2.ROLEUSERを削除DROP ROLE ROLEUSER;3.ロールを確認SELECT * FROM DBA_ROLE_PRIVS;

Oracle

SQL構文下記

1.数字のみ抽出SELECT REGEXP_REPLACE('1丁目8番地6号','','') FROM DUAL実行結果:1862.数字のみ削除SELECT REGEXP_REPLACE('1丁目2番地3号', ...

Oracle

メモ下記

1.ジョブ確認SQL> set pages 1000SQL> set line 100SQL> column job_name format a30SQL> select job_name,st ...