SQL & PL/SQL

Hello, I'm beginner of PL/SQL and a have a problem with Nested Table:


I need to know, how to count rows from my nested table

I have a colum, who is nested table (collections) of my objects, I want in one select query get all records where count is for example 2:

select * from table_with_nested where nested_table.COUNT = 4;

when I use function in PL/SQL and I have nested table as variable function of collection 'COUNT' work, but in select query I can't use this function of collection