This looks like Oracle code. You'd be much better off hitting up on an Oracle forum.
As a side bar, if anyone asked me for such a data dictionary on 1,000s of tables in SQL Server, I'd point them to learning how to right click on a database and learning how to use the "Generate Scripts" task. I worked with Oracle many years ago and a similar thing exists there. I just don't remember how to do it.
--Jeff Moden
Change is inevitable... Change for the better is not.