display total number of rows with function and criteria
This query displays column c1, c2 and c3. The data of column c3 converts number into date from using function.
SELECT a.c1, a.c2, integerdate(a.c3)
FROM t141 a
The below query display all the tables starts with 'T' charcter.
select count(*) from user_tables where table_name like 'T%'
but I need to display total number of rows from all the above tables start start with 'T' character using the below criteria.
WHERE integerdate( c3 ) < add_months( sysdate, -36 )
Can you please write the SQL statemetn to display total number of rows from each tables start with 'T' character.
Thanks in advance.