select count(*)

In SQL Server, I can do the following queries:

select col1, col2, count(*) total_record from table1

select col1, col2, (select count(*) from table1) total_record from table1

In Oracle, how can I do that?

--
---
http://www.washington.edu/pine/faq/ Received on Tue Aug 10 1999 - 04:00:09 CDT