Home » SQL & PL/SQL » SQL & PL/SQL » display total number of rows with function and criteria
display total number of rows with function and criteria [message #206514] Thu, 30 November 2006 06:54 Go to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member


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.
Re: display total number of rows with function and criteria [message #206929 is a reply to message #206514] Sat, 02 December 2006 07:25 Go to previous message
michael_bialik
Messages: 619
Registered: July 2006
Senior Member
Search for NDS - Native Dynamic SQL
Previous Topic: Query optimization
Next Topic: How can I store sql query result in different tabs of excel
Goto Forum:
  


Current Time: Sat Aug 19 15:38:24 CDT 2017

Total time taken to generate the page: 0.02768 seconds