SELECT COUNT(*) INTO FROM multiple tables

I’m trying to do a SELECT COUNT(*) to multiple tables.
IM doing this query with PL/SQL.

My Select code Looks like this

Select a.name, b.type, c.id FROM dat_names a, dat_types b, dat_id c WHERE b.type = 'B' AND c.id = '200';

The code works very well but i’d like to know how many rows there are.


Source: sql

Leave a Reply