How to select all columns, and a count(*) in the same query

Question

In often use in TSQL the following query :

SELECT COUNT(*), *  FROM CUSTOMER c  WHERE c.Name like 'foo%'; 

When I try to execute this query in Oracle SQL Developer it doesn't work and throws me an error:

"Missing expression"

What is the good syntax ?

Thanks in advance.

Answer 1

This will perform better:

SELECT COUNT(*) OVER (), c.* FROM CUSTOMER c  WHERE c.Name like 'foo%';