How to list all constraints in Oracle database

You can list all constraints and tables to which they are linked via this SQL statement: SELECT constraint_name, Decode(constraint_type, ‘C’, ‘Check constraint on a table’, ‘P’, ‘Primary key’, ‘U’, ‘Unique key’, ‘R’, ‘Referential integrity’, ‘V’, ‘With check option, on a view’, ‘O’, ‘With read only, on a view’, ‘H’, ‘Hash expression’, ‘F’, ‘Constraint that involves […]

How to run ClamAV as Windows Service

ClamAV (Clam AntiVirus) is a free, cross-platform and open-source antivirus software toolkit which can detect many types of malicious software. When you’re building Java application which needs antivirus then ClamAV is a really good choice. You can send a byte array via API and check it for viruses. For a long time, we operated ClamAV […]