Many a times we need to query document details from UCM.
Having it done by a SQL query allows us to put the details in report as well.
Below are the two useful UCM tables with schema :
Schema: fusion_ocserver11g
Tables: revisions and documents
How to use?
Schema.Table
Example:
fusion_ocserver11g.revisions
fusion_ocserver11g.documents
No comments:
Post a Comment