Tracnac

Escape wildcard characters The LIKE keyword allows for string searches. The '_' wild card character is used to match exactly one character, while '%' is used to match zero or more occurrences of any characters. These characters can be escaped in SQL. Examples:

SELECT name FROM emp
WHERE id LIKE '%/_%' ESCAPE '/';


SELECT name FROM emp
WHERE id LIKE '%\%%' ESCAPE '\';

Tracnac

col c1 format a15 heading 'snapshot|date'
col c2 format a25 heading 'table|name'
col c3 format 999,999,999,999 heading 'space|used|total'
col c4 format 999,999,999,999 heading 'space|allocated|total'


select
to_char(begin_interval_time,'yy/mm/dd hh24:mm') c1,
object_name c2,

Tracnac

ops$tkyte%ORA11GR2> !cat /tmp/run_ls.sh #/bin/bash cd /tmp /bin/ls -l

ops$tkyte%ORA11GR2> CREATE or replace DIRECTORY exec_dir AS '/tmp' 2 /

Tracnac

select current_block,next_block,max(level)
from (select block_id as current_block,block_id+BLOCKS as next_block from dba_extents where owner='<OWNER>' and SEGMENT_NAME='CONT' order by current_block) blocks
connect by prior next_block=current_block
group by current_block,next_block
order by current_block;

Tracnac

sqlplus -s / as sysdba << EOF
ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-RR HH24:MI:SS';
select '${i}' from dual;
select SEQUENCE#,first_time from v\$archived_log where sequence# = (select max(sequence#) from v\$archived_log) order by first_time;
select sequence#, first_time from v\$archived_log where (select resetlogs_change# from v\$database) between first_change# and next_change#;
quit

Tracnac

• Power off device
• Press and hold Menu and Enter (joystick pressed in)
• Press and release Light while continuing to hold Menu and Enter
• Select Yes once the Do you really want to erase all user data? message appears
• Leave the device outside with a clear view of the sky for a minimum of 20 minutes to acquire satellite data.

Tracnac

1 DECLARE
2 RetVal VARCHAR2(100);
3 BEGIN
4 dbms_system.get_env('ORACLE_HOME', RetVal);
5 dbms_output.put_line(RetVal);
6* END;

Tracnac

col "Parameter" for a48
col "Session Value" for a32
col "Instance Value" for a32
select a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value"
from x$ksppi a, x$ksppcv b, x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and substr(ksppinm,1,1)='_'
and ksppinm like '%&1.%'
order by a.ksppinm;

Tracnac

SELECT DECODE (b.table_name, NULL, 'dead', 'ok') status,
a.table_name,
a.columns fk_columns,
b.columns index_columns
FROM ( SELECT a.table_name,
a.constraint_name,
LISTAGG (a.column_name, ',')
WITHIN GROUP (ORDER BY a.position)
columns

Tracnac

https://richardfoote.files.wordpress.com/2007/12/index-internals-rebuilding-the-truth.pdf