[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_sqlstatement := 'SELECT COUNT(DISTINCT ' ||
p_tablename ||
') FROM ' ||p_owner||'.'||
p_arctablename;
|| ' AS SELECT * ' || 'FROM ' || p_tablename ||
' WHERE ROWNUM < 1';
' AS SELECT * ' || 'FROM ' || p_tablename ||
' WHERE ROWNUM < 1';
SELECT table_name
FROM sy_purg_def_act
WHERE purge_type = cp_purge_type;
SELECT table_name
, owner
FROM all_tables
WHERE SUBSTR(table_name,8) = cp_tablename
AND SUBSTR(table_name,7,1) = '_'
AND SUBSTR(table_name,6,1) IN
('1','2','3','4','5','6','7','8','9','0')
AND SUBSTR(table_name,5,1) IN
('1','2','3','4','5','6','7','8','9','0')
AND SUBSTR(table_name,4,1) IN
('1','2','3','4','5','6','7','8','9','0')
AND SUBSTR(table_name,3,1) IN
('1','2','3','4','5','6','7','8','9','0')
AND SUBSTR(table_name,2,1) IN
('1','2','3','4','5','6','7','8','9','0')
AND SUBSTR(table_name,1,1) = 'A'
AND owner='GMA';
|| 'SELECT * FROM ' || l_owner
|| '.' || l_arctable.table_name;
|| 'SELECT * FROM ' ||
l_viewtable.table_name || ' WHERE ROWNUM < 1';
SELECT table_name,archive_action
FROM sy_purg_def_act
WHERE
Purge_type=(select PURGE_TYPE from sy_purg_mst where Purge_id=P_purge_id);
SELECT b.table_name pk_table_name,a.owner, a.table_name,a.CONSTRAINT_NAME,a.status
FROM all_constraints a, all_constraints b
WHERE a.r_constraint_name = b.constraint_name
-- AND a.constraint_type = 'R'
-- AND b.constraint_type = 'P'
AND a.r_owner=b.owner
AND b.owner not in ('SYS', 'SYSTEM')
AND b.table_name = upper(c_tablename)
ORDER by b.TABLE_NAME;
select VP.value db_block_size
, VT7.type_size sb2
, VT6.type_size ub1
, VT5.type_size kcbh
, VT4.type_size ub4
, VT3.type_size ktbbh
, VT2.type_size ktbit
, VT1.type_size kdbh
from v$type_size VT7
, v$type_size VT6
, v$type_size VT5
, v$type_size VT4
, v$type_size VT3
, v$type_size VT2
, v$type_size VT1
, v$parameter VP
where upper(VT7.TYPE) = 'SB2'
and upper(VT6.TYPE) = 'UB1'
and upper(VT5.TYPE) = 'KCBH'
and upper(VT4.TYPE) = 'UB4'
and upper(VT3.TYPE) = 'KTBBH'
and upper(VT2.TYPE) = 'KTBIT'
and upper(VT1.TYPE) = 'KDBH'
and upper(VP.name) = 'DB_BLOCK_SIZE';
select VT8.type_size kdbt
from v$type_size VT8
where upper(VT8.TYPE) = 'KDBT'
union
select VT9.type_size
from v$type_size VT9
where upper(VT9.TYPE) = 'KCBH'
and not exists (select VT0.type_size kdbt
from v$type_size VT0
where upper(VT0.TYPE) = 'KDBT');
select sum(data_length + decode(floor(data_length/250),0,1,3))
from user_tab_columns
where table_name = c_tablename;
l_countstatement := 'SELECT COUNT(*) ' ||
'FROM DBA_FREE_SPACE ' ||
'WHERE TABLESPACE_NAME = ' ||
'''' || p_tablespace_name || '''';
select UIX.index_name index_name
, UIX.table_name indexed_table
, decode(UIX.uniqueness,
'NONUNIQUE',NULL,
'UNIQUE' ,' UNIQUE',
NULL) uniqueness
, UIX.tablespace_name tablespace_name
, UIX.ini_trans ini_trans
, UIX.max_trans max_trans
, decode(nvl(UIX.initial_extent,9999999999),
9999999999,NULL,
' INITIAL '
|| to_char(UIX.initial_extent))
initial_extent
, decode(nvl(UIX.next_extent,9999999999),
9999999999,NULL,
' NEXT '
|| to_char(UIX.next_extent))
next_extent
, decode(nvl(UIX.freelists,9999999999),
9999999999,NULL,
' FREELISTS '
|| to_char(UIX.freelists))
freelists
, decode(nvl(UIX.freelist_groups,9999999999),
9999999999,NULL,
' FREELIST GROUPS '
|| to_char(UIX.freelist_groups))
freelist_groups
, UIX.min_extents min_extents
, UIX.max_extents max_extents
, UIX.pct_increase pct_increase
, UIX.pct_free pct_free
, UIC.table_name indexed_column_table
, UIC.column_name column_name
from user_ind_columns UIC
, user_indexes UIX
where UIC.index_name = UIX.index_name
and UIX.table_name = c_table_name
order by UIX.index_name
, UIC.column_position;