Skip to content

Instantly share code, notes, and snippets.

View glandaverde's full-sized avatar

glandaverde

0 followers · 1 following
View GitHub Profile
@glandaverde
glandaverde / table_rowcount.sql
Last active December 13, 2017 22:05
table historic count
WITH TableList AS  
(SELECT object_id,          
OWNER,          
object_name     
FROM dba_objects    
WHERE object_type='TABLE'      
AND object_name  = UPPER(:TNAME)  ) ,  
HistTableInfo AS  
(SELECT TableList.OWNER,          
OBJECT_NAME