You could use OQL (Object Query Language) to perform different queries to the persistent objects. Please have in mind that when you use OQL you perform queries to persistent classes and not to database tables. The OQL queries will be the same no matter what database you use. OQL differs from SQL in that:

• OQL supports object referencing within tables. Objects can be nested within objects.
• Not all SQL keywords are supported within OQL. Keywords that are not relevant to Netcool/Precision IP have been removed from the syntax.
• OQL can perform mathematical computations within OQL statements.