if the pl/sql records are defiled at sql level (i.e. type declaration rather than in packages), you probably can write a block of plsql that will churn out the code to do comparison for you. If it is in packages, you can still fish it out, but it is probably tough. ps: unnecessary lines deleted to please the quota police. Raj ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY'; -- //www.freelists.org/webpage/oracle-l