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 ...

oracle

メモ下記

1.ジョブ一覧確認SQL> set pages 999SQL> SELECT job_name FROM dba_scheduler_jobs;2.ジョブ作成SQL> BEGINDBMS_SCHEDU ...

oracle

方法下記

1.ユーザ切り替える# su - oracle2.sqlplusに接続$ sqlplus/as sysdbaSQL> SELECT * FROM V$VERSION;BANNER----------------- ...