--The NDS implementation:
create or replace function emp_row_count1
(n1 in varchar2) return PLS_INTEGER
-- pls_integer less storage than number
is
r_count PLS_INTEGER;
BEGIN
EXECUTE IMMEDIATE 'SELECT COUNT(*) ROW_COUNT FROM '||n1 into r_count;
return r_count;
end;
/