Nagio oracle check no primary key tables

gistfile1.sql

Select     tables.owner || '.' ||
tables.table_name
as   table_owner
From               all_tables      tables,
(Select
owner,
TABLE_NAME,
constraint_type,
CONSTRAINT_NAME
FROM ALL_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'P'     /* list of all tables with PK */
)  constr
Where              tables.owner = constr.owner (+)
And                tables.table_name = constr.table_name (+)
and   tables.owner = 'CQGZF'
And                constr.owner IS NULL
And                constr.table_name IS NULL
ORDER BY 1;