Query:
=====
set lines 300 pages 3000
col table_name for a50
col owner for a20
col degree for a9
set feed off
alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
set feed on
select owner,table_name,degree,num_rows,last_analyzed FROM dba_tables
WHERE upper(owner) = upper('&owner') AND upper(table_name) = upper('&table_name');
=====
set lines 300 pages 3000
col table_name for a50
col owner for a20
col degree for a9
set feed off
alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
set feed on
select owner,table_name,degree,num_rows,last_analyzed FROM dba_tables
WHERE upper(owner) = upper('&owner') AND upper(table_name) = upper('&table_name');
Input: Owen and Table name
Note: This result is accurate only when statistics gathered the respective table.

No comments:
Post a Comment